hash8() function

The hash8() function returns a 64-bit hash of data.

The function provides 2⁶⁴ distinct return values and is intended for data retrieval (lookups).

Syntax

The hash8() function has the following syntax:

int8 = hash8(varchar data [, int algorithm]);
int8 = hash8(nvarchar data [, int algorithm]);

The data value specifies the varchar or nvarchar value to hash.

Only one algorithm value is supported for this hashing function: 0, which indicates the Jenkins algorithm.

The function returns hashed data.

select hash8('Netezza');
        HASH8
---------------------
 6256861227618928690
(1 row)