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]