From: | David Kerr <dmk(at)mr-paradox(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: UUID datatype question |
Date: | 2009-07-13 19:30:10 |
Message-ID: | 20090713193010.GA87545@mr-paradox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Jul 13, 2009 at 03:28:09PM -0400, Tom Lane wrote:
- David Kerr <dmk(at)mr-paradox(dot)net> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2009-07-13 19:32:03 | Re: UUID datatype question |
Previous Message | Sam Mason | 2009-07-13 19:29:24 | Re: pg_dump of a big table |