pghashlib/hashlib.sql.in at master · olsender/pghashlib · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

CREATE OR REPLACE FUNCTION hash_string(text, text) RETURNS int4
	AS 'MODULE_PATHNAME', 'pg_hash_string' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION hash_string(bytea, text) RETURNS int4
	AS 'MODULE_PATHNAME', 'pg_hash_string' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION hash_string(text, text, int4) RETURNS int4
	AS 'MODULE_PATHNAME', 'pg_hash_string' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION hash_string(bytea, text, int4) RETURNS int4
	AS 'MODULE_PATHNAME', 'pg_hash_string' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION hash64_string(text, text) RETURNS int8
	AS 'MODULE_PATHNAME', 'pg_hash64_string' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION hash64_string(bytea, text) RETURNS int8
	AS 'MODULE_PATHNAME', 'pg_hash64_string' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION hash64_string(text, text, int8) RETURNS int8
	AS 'MODULE_PATHNAME', 'pg_hash64_string' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION hash64_string(bytea, text, int8) RETURNS int8
	AS 'MODULE_PATHNAME', 'pg_hash64_string' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION hash128_string(text, text) RETURNS bytea
	AS 'MODULE_PATHNAME', 'pg_hash128_string' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION hash128_string(bytea, text) RETURNS bytea
	AS 'MODULE_PATHNAME', 'pg_hash128_string' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION hash_int4(int4, text) RETURNS int4
	AS 'MODULE_PATHNAME', 'pg_hash_int32' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION hash_int4(int8, text) RETURNS int4
	AS 'MODULE_PATHNAME', 'pg_hash_int32from64' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION hash_int8(int8, text) RETURNS int8
	AS 'MODULE_PATHNAME', 'pg_hash_int64' LANGUAGE C IMMUTABLE STRICT;