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