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(at)kineticode(dot)com ICQ: 15726394
http://www.kineticode.com/ Yahoo!: dew7e
Jabber: Theory(at)jabber(dot)org
Kineticode. Setting knowledge in motion.[sm]