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