diff options
Diffstat (limited to 'shared/ossp_uuid/pgsql/uuid.sql.in')
| -rw-r--r-- | shared/ossp_uuid/pgsql/uuid.sql.in | 244 |
1 files changed, 0 insertions, 244 deletions
diff --git a/shared/ossp_uuid/pgsql/uuid.sql.in b/shared/ossp_uuid/pgsql/uuid.sql.in deleted file mode 100644 index c2f01fcc..00000000 --- a/shared/ossp_uuid/pgsql/uuid.sql.in +++ /dev/null @@ -1,244 +0,0 @@ --- --- OSSP uuid - Universally Unique Identifier --- Copyright (c) 2004-2007 Ralf S. Engelschall <rse@engelschall.com> --- Copyright (c) 2004-2007 The OSSP Project <http://www.ossp.org/> --- --- This file is part of OSSP uuid, a library for the generation --- of UUIDs which can found at http://www.ossp.org/pkg/lib/uuid/ --- --- Permission to use, copy, modify, and distribute this software for --- any purpose with or without fee is hereby granted, provided that --- the above copyright notice and this permission notice appear in all --- copies. --- --- THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED --- WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF --- MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. --- IN NO EVENT SHALL THE AUTHORS AND COPYRIGHT HOLDERS AND THEIR --- CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, --- SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT --- LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF --- USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND --- ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, --- OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT --- OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF --- SUCH DAMAGE. --- --- uuid.sql: PostgreSQL Binding (SQL part) --- - --- --- prolog --- - -SET search_path TO public; -SET client_min_messages TO warning; - -DROP FUNCTION uuid_in(CSTRING) CASCADE; -DROP FUNCTION uuid_out(uuid) CASCADE; -DROP FUNCTION uuid_recv(INTERNAL) CASCADE; -DROP FUNCTION uuid_send(uuid) CASCADE; -DROP TYPE uuid CASCADE; -DROP CAST (CSTRING AS uuid) CASCADE; -DROP CAST (uuid AS CSTRING) CASCADE; - -DROP FUNCTION uuid(CSTRING) CASCADE; -DROP FUNCTION uuid(INTEGER) CASCADE; -DROP FUNCTION uuid(INTEGER, CSTRING, CSTRING) CASCADE; - -DROP FUNCTION uuid_eq(uuid) CASCADE; -DROP FUNCTION uuid_ne(uuid) CASCADE; -DROP FUNCTION uuid_lt(uuid, uuid) CASCADE; -DROP FUNCTION uuid_gt(uuid, uuid) CASCADE; -DROP FUNCTION uuid_le(uuid, uuid) CASCADE; -DROP FUNCTION uuid_ge(uuid, uuid) CASCADE; -DROP OPERATOR =(uuid,uuid) CASCADE; -DROP OPERATOR <>(uuid,uuid) CASCADE; -DROP OPERATOR <(uuid,uuid) CASCADE; -DROP OPERATOR >(uuid,uuid) CASCADE; -DROP OPERATOR <=(uuid,uuid) CASCADE; -DROP OPERATOR >=(uuid,uuid) CASCADE; - -DROP FUNCTION uuid_hash(uuid) CASCADE; -DROP FUNCTION uuid_cmp(uuid, uuid) CASCADE; -DROP OPERATOR CLASS uuid_ops USING hash CASCADE; -DROP OPERATOR CLASS uuid_ops USING btree CASCADE; - -BEGIN; - --- --- the UUID data type --- - -CREATE FUNCTION - uuid_in(CSTRING) RETURNS uuid - STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_in'; - -CREATE FUNCTION - uuid_out(uuid) RETURNS CSTRING - STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_out'; - -CREATE FUNCTION - uuid_recv(INTERNAL) RETURNS uuid - STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_recv'; - -CREATE FUNCTION - uuid_send(uuid) RETURNS BYTEA - STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_send'; - -CREATE TYPE uuid ( - INPUT = uuid_in, -- for SQL input - OUTPUT = uuid_out, -- for SQL output - RECEIVE = uuid_recv, -- for DB input - SEND = uuid_send, -- for DB output - DEFAULT = 'uuid(1)', - INTERNALLENGTH = 16, - ALIGNMENT = char -); - -COMMENT ON TYPE uuid - IS 'UUID type'; - --- CREATE CAST (CSTRING AS uuid) --- WITH FUNCTION uuid_in(CSTRING) AS ASSIGNMENT; --- --- CREATE CAST (uuid AS CSTRING) --- WITH FUNCTION uuid_out(uuid) AS ASSIGNMENT; - --- --- the UUID constructor function --- - -CREATE FUNCTION - uuid(CSTRING) RETURNS uuid - IMMUTABLE STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_in'; - -CREATE FUNCTION - uuid(INTEGER) RETURNS uuid - VOLATILE CALLED ON NULL INPUT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_make'; - -CREATE FUNCTION - uuid(INTEGER, CSTRING, CSTRING) RETURNS uuid - VOLATILE CALLED ON NULL INPUT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_make'; - --- --- the UUID operators --- - -CREATE FUNCTION - uuid_eq(uuid, uuid) RETURNS BOOL - IMMUTABLE STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_eq'; - -CREATE FUNCTION - uuid_ne(uuid, uuid) RETURNS BOOL - IMMUTABLE STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_ne'; - -CREATE FUNCTION - uuid_lt(uuid, uuid) RETURNS BOOL - IMMUTABLE STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_lt'; - -CREATE FUNCTION - uuid_gt(uuid, uuid) RETURNS BOOL - IMMUTABLE STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_gt'; - -CREATE FUNCTION - uuid_le(uuid, uuid) RETURNS BOOL - IMMUTABLE STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_le'; - -CREATE FUNCTION - uuid_ge(uuid, uuid) RETURNS BOOL - IMMUTABLE STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_ge'; - -CREATE OPERATOR = ( - leftarg = uuid, - rightarg = uuid, - negator = <>, - procedure = uuid_eq -); - -CREATE OPERATOR <> ( - leftarg = uuid, - rightarg = uuid, - negator = =, - procedure = uuid_ne -); - -CREATE OPERATOR < ( - leftarg = uuid, - rightarg = uuid, - commutator = >, - negator = >=, - procedure = uuid_lt -); - -CREATE OPERATOR > ( - leftarg = uuid, - rightarg = uuid, - commutator = <, - negator = <=, - procedure = uuid_gt -); - -CREATE OPERATOR <= ( - leftarg = uuid, - rightarg = uuid, - commutator = >=, - negator = >, - procedure = uuid_le -); - -CREATE OPERATOR >= ( - leftarg = uuid, - rightarg = uuid, - commutator = <=, - negator = <, - procedure = uuid_ge -); - --- --- the UUID support for indexing --- - -CREATE FUNCTION - uuid_hash(uuid) RETURNS INTEGER - IMMUTABLE STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_hash'; - -CREATE FUNCTION - uuid_cmp(uuid, uuid) RETURNS INTEGER - IMMUTABLE STRICT - LANGUAGE C AS 'MODULE_PATHNAME', 'pg_uuid_cmp'; - -CREATE OPERATOR CLASS uuid_ops - DEFAULT FOR TYPE uuid USING hash AS - OPERATOR 1 =, -- 1: equal - FUNCTION 1 uuid_hash(uuid); - -CREATE OPERATOR CLASS uuid_ops - DEFAULT FOR TYPE uuid USING btree AS - OPERATOR 1 <, -- 1: less than - OPERATOR 2 <=, -- 2: less than or equal - OPERATOR 3 =, -- 3: equal - OPERATOR 4 >=, -- 4: greater than or equal - OPERATOR 5 >, -- 5: greater than - FUNCTION 1 uuid_cmp(uuid, uuid); - --- --- epilog --- - -COMMIT; - |