------------------------------------------------------------------------ -- $Source: /local/data/cvs/yellowbank/postgres/src/uuid/y_uuid.sql,v $ -- $Revision: 1.4 $ -- $State: Exp $ -- $Date: 2006/10/20 14:05:27 $ -- $Author: yrp001 $ -- $Locker: $ ------------------------------------------------------------------------ ------------------------------------------------------------------------ -- Copyright (c) 2006 -- Ronald Peterson -- (Y) Yellowbank -- All rights reserved. Applicable BSD license terms can be found in -- the associated LICENSE file. ------------------------------------------------------------------------ ------------------------------------------------------------------------ CREATE OR REPLACE FUNCTION y_uuid_generate() RETURNS bytea AS 'y_uuid.so', 'y_uuid_generate' LANGUAGE C STRICT IMMUTABLE; ------------------------------------------------------------------------ ------------------------------------------------------------------------ CREATE OR REPLACE FUNCTION y_uuid_generate_random() RETURNS bytea AS 'y_uuid.so', 'y_uuid_generate_random' LANGUAGE C STRICT IMMUTABLE; ------------------------------------------------------------------------ ------------------------------------------------------------------------ CREATE OR REPLACE FUNCTION y_uuid_generate_time() RETURNS bytea AS 'y_uuid.so', 'y_uuid_generate_time' LANGUAGE C STRICT IMMUTABLE; ------------------------------------------------------------------------ ------------------------------------------------------------------------ CREATE OR REPLACE FUNCTION y_uuid_parse(text) RETURNS bytea AS 'y_uuid.so', 'y_uuid_parse' LANGUAGE C STRICT IMMUTABLE; ------------------------------------------------------------------------ ------------------------------------------------------------------------ CREATE OR REPLACE FUNCTION y_uuid_unparse(bytea) RETURNS text AS 'y_uuid.so', 'y_uuid_unparse' LANGUAGE C STRICT IMMUTABLE; ------------------------------------------------------------------------ ------------------------------------------------------------------------ CREATE OR REPLACE FUNCTION y_uuid_time(bytea) RETURNS timestamp AS 'y_uuid.so', 'y_uuid_time' LANGUAGE C STRICT IMMUTABLE; ------------------------------------------------------------------------ ------------------------------------------------------------------------ -- CREATE OR REPLACE FUNCTION -- y_uuid_time_text(bytea) -- RETURNS -- text -- AS -- 'y_uuid.so', 'y_uuid_time_text' -- LANGUAGE -- C -- STRICT IMMUTABLE; ------------------------------------------------------------------------