Contents:
Calculates the CRC-64 hash of a text expression
CRC64( expr ) --> BIGINT
Parameter
Description
expr
Text expression (TEXT)
TEXT
Returns a CRC-64 hash of the text input, of type BIGINT.
BIGINT
Note
If the input value is NULL, the result is NULL.
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