CRC64

The CRC64 function calculates the CRC-64 hash of a text expression.

Syntax

CRC64( expr ) --> BIGINT

Parameter	Description
`expr`	Text expression (`TEXT`)

Returns a CRC-64 hash of the text input, of type BIGINT.

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