David Kerr <[email protected]> writes:
> Tried w/o escaping:
> insert into testuuid values ('{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}');
> ERROR: invalid input syntax for uuid: "{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}"
Works for me:
regression=# select '{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}'::uuid;
uuid
--------------------------------------
a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11
(1 row)
I wonder whether you are reading the 8.4 docs for an 8.3 installation?
(I believe that 8.3 takes braces too ... but it's pickier about where
it allows dashes.)
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
