From: | Thomas Hallgren <thomas(at)tada(dot)se> |
---|---|
To: | Jan de Visser <jdevisser(at)digitalfairway(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Cc: | Gevik Babakhani <pgdev(at)xs4all(dot)nl> |
Subject: | Re: Proposal for GUID datatype |
Date: | 2006-09-11 15:05:23 |
Message-ID: | 45057B33.4030708@tada.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Jan de Visser wrote:
> On Friday 08 September 2006 15:18, Gevik Babakhani wrote:
>> 2a) Three input formats are supported.
>> example:
>> insert into tbl (fld) values('1dfb39af-b56a-40b8-a903-b5b31567c3ce');
>> insert into tbl (fld) values('{1dfb39af-b56a-40b8-a903-b5b31567c3ce}');
>> insert into tbl (fld) values('1dfb39afb56a40b8a903b5b31567c3ce');
>
> Please extend your list. java's RMI package generates UIDs with the following
> format:
>
> [head order 21:19]$ bsh.sh
> BeanShell 1.3.0 - by Pat Niemeyer (pat(at)pat(dot)net)
> bsh % print(new java.rmi.server.UID());
> 3b732da7:10d9029b3eb:-8000
> bsh %
>
> So forms that use colons instead of dashes seem appropriate.
>
> Or better still, make it configurable.
>
> jan
>
RMI UID's has nothing in common with UUID's so I fail to see how they
have any relevance here. I've never seen any other representation of the
UUID's that the two that Gevik wants to support. Please note that UUID
is a very well known concept and not an arbitrary 128 bit storage.
http://en.wikipedia.org/wiki/UUID is a good source of information. The
appointed RFC actually contains source code.
Kind Regards,
Thomas Hallgren
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Wong | 2006-09-11 15:20:35 | Re: Lock partitions |
Previous Message | Martijn van Oosterhout | 2006-09-11 14:55:14 | Re: Fixed length data types issue |