CRC64

Calculates the CRC-64 hash of a text expression

Syntax

CRC64( expr ) --> BIGINT

CRC64_JOIN( expr ) --> BIGINT

Arguments

Parameter Description
expr Text expression (VARCHAR, TEXT)

Returns

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

Notes

  • If the input value is NULL, the result is NULL.
  • The CRC64_JOIN variant skips leading whitespace, when used as a JOIN key

Examples

Calculate a CRC-64 hash of a string

numbers=> SELECT CRC64(x) FROM
.    (VALUES ('This is a relatively long text string, that can be converted to a shorter hash' :: varchar(80)))
.    as t(x);
crc64
--------------------
-9085161068710498500