Re: UUID datatype question

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: David Kerr <dmk(at)mr-paradox(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: UUID datatype question
Date: 2009-07-13 19:32:03
Message-ID: 20090713193203.GK4930@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

> (I believe that 8.3 takes braces too ... but it's pickier about where
> it allows dashes.)

This is what the 8.3 comment says:

/*
* We allow UUIDs in three input formats: 8x-4x-4x-4x-12x,
* {8x-4x-4x-4x-12x}, and 32x, where "nx" means n hexadecimal digits
* (only the first format is used for output). We convert the first
* two formats into the latter format before further processing.
*/

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Weslee Bilodeau 2009-07-13 20:03:49 Re: LAPUG Social - Tuesday Evening July 14
Previous Message David Kerr 2009-07-13 19:30:10 Re: UUID datatype question