CRC64¶
The CRC64
function calculates the CRC-64 hash of a text expression.
Syntax¶
CRC64( expr ) --> BIGINT
Arguments¶
Parameter |
Description |
---|---|
|
Text expression ( |
Returns¶
Returns a CRC-64 hash of the text input, of type BIGINT
.
If the input value is NULL
, the result is NULL
.
Examples¶
SELECT CRC64(x) FROM (VALUES ('This is a relatively long text string, that can be converted to a shorter hash' :: text)) as t(x);
-8397827068206190216