Re: UUID datatype question

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

In response to

Browse pgsql-general by date

  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