Re: GUIDs

On Thursday, November 13, 2003, at 08:30  PM, Peter Eisentraut wrote:

> Bbytea with the binary or the hex?
>
> Binary or hex what?

Representation of the UUID.

>> And isn't it a bit of a waste to add the extra 4 bytes when I'll only
>> ever need 16?
>
> Sure, but if you want to avoid that, you'll have to implement your own
> data type.  Actually, I think someone has already done that for GUID.
> If
> you search the archives you might find out about it.

Sure enough. Josh just mentioned this to me:

   http://gborg.postgresql.org/project/pguuid/projdisplay.php

Looks like 1.0.0 was released June 17, 2003. I wonder how robust it is?

Cheers,

David

--
David Wheeler                                     AIM: dwTheory
david@kineticode.com                              ICQ: 15726394
http://www.kineticode.com/                     Yahoo!: dew7e
                                                Jabber: Theory@jabber.org
Kineticode. Setting knowledge in motion.[sm]