CRC64¶
Calculates the CRC-64 hash of a text expression
Syntax¶
CRC64( expr ) --> BIGINT
CRC64_JOIN( expr ) --> BIGINT
Arguments¶
Parameter |
Description |
---|---|
|
Text expression ( |
Returns¶
Returns a CRC-64 hash of the text input, of type BIGINT
.
Notes¶
If the input value is NULL, the result is NULL.
The
CRC64_JOIN
can be used withVARCHAR
only. It can not be used withTEXT
.The
CRC64_JOIN
variant ignores leading whitespace when used as aJOIN
key.