1 /* $PostgreSQL: pgsql/contrib/uuid-ossp/uuid-ossp.sql.in,v 1.4 2007/11/13 00:20:36 tgl Exp $ */
3 -- Adjust this setting to control where the objects get created.
4 SET search_path = public;
6 CREATE OR REPLACE FUNCTION uuid_nil()
8 AS 'MODULE_PATHNAME', 'uuid_nil'
9 IMMUTABLE STRICT LANGUAGE C;
11 CREATE OR REPLACE FUNCTION uuid_ns_dns()
13 AS 'MODULE_PATHNAME', 'uuid_ns_dns'
14 IMMUTABLE STRICT LANGUAGE C;
16 CREATE OR REPLACE FUNCTION uuid_ns_url()
18 AS 'MODULE_PATHNAME', 'uuid_ns_url'
19 IMMUTABLE STRICT LANGUAGE C;
21 CREATE OR REPLACE FUNCTION uuid_ns_oid()
23 AS 'MODULE_PATHNAME', 'uuid_ns_oid'
24 IMMUTABLE STRICT LANGUAGE C;
26 CREATE OR REPLACE FUNCTION uuid_ns_x500()
28 AS 'MODULE_PATHNAME', 'uuid_ns_x500'
29 IMMUTABLE STRICT LANGUAGE C;
31 CREATE OR REPLACE FUNCTION uuid_generate_v1()
33 AS 'MODULE_PATHNAME', 'uuid_generate_v1'
34 VOLATILE STRICT LANGUAGE C;
36 CREATE OR REPLACE FUNCTION uuid_generate_v1mc()
38 AS 'MODULE_PATHNAME', 'uuid_generate_v1mc'
39 VOLATILE STRICT LANGUAGE C;
41 CREATE OR REPLACE FUNCTION uuid_generate_v3(namespace uuid, name text)
43 AS 'MODULE_PATHNAME', 'uuid_generate_v3'
44 IMMUTABLE STRICT LANGUAGE C;
46 CREATE OR REPLACE FUNCTION uuid_generate_v4()
48 AS 'MODULE_PATHNAME', 'uuid_generate_v4'
49 VOLATILE STRICT LANGUAGE C;
51 CREATE OR REPLACE FUNCTION uuid_generate_v5(namespace uuid, name text)
53 AS 'MODULE_PATHNAME', 'uuid_generate_v5'
54 IMMUTABLE STRICT LANGUAGE C;