Thanks for the suggestion of casting the hex string to uuid. That works. I tried the standard syntax using "CAST":
VALUES ( CAST( $1 AS uuid) ) --Basil Bourque > How about: > CREATE OR REPLACE FUNCTION public.uuid_write_(character varying) > RETURNS boolean > LANGUAGE plpgsql > AS $function$ > > BEGIN > INSERT INTO uuid_tbl_ ( uuid_col_ ) > VALUES ( $1::uuid ); > RETURN True; > END; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
