On Mon, Jul 13, 2009 at 03:28:09PM -0400, Tom Lane wrote:
- David Kerr <dmk@xxxxxxxxxxxxxx> 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
-
Ha, yeah that'd be it.
Thanks
Dave
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
