/usr/share/doc/postgresql-comparator/README.pgc_checksum is in postgresql-comparator 2.2.6-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | provide fast NOT cryptographycally-secure checksum functions
for TEXT, results being of INT2, INT4 and INT8 types.
The cksum* functions are based on Jenkins hash.
The fnv* functions are based on FNV version 1a hash.
load with:
sh> psql < <path-to-postgresql>/share/contrib/pgc_checksum.sql
use as:
psql> SELECT cksum2('some text');
psql> SELECT cksum4('some text');
psql> SELECT cksum8('some text');
psql> SELECT fnv2('some text');
psql> SELECT fnv4('some text');
psql> SELECT fnv8('some text');
For cksum, an NULL text results in hash value 0 and
an empty text results in some predefined value.
|