Re: GUIDs - Mailing list pgsql-general

From David Wheeler
Subject Re: GUIDs
Date
Msg-id AC7128E8-1642-11D8-9545-0003931A964A@kineticode.com
Whole thread Raw
In response to Re: GUIDs  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
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]


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: GUIDs
Next
From: jini us
Date:
Subject: Re: embedded postgresql + C++ IDE