CRC64

Calculates the CRC-64 hash of a text expression

Syntax

CRC64( expr ) --> BIGINT

Arguments

Parameter

Description

expr

Text expression (TEXT)

Returns

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

Note

If the input value is NULL, the result is NULL.

Examples

Calculate a CRC-64 hash of a string

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