From: | Jan de Visser <jdevisser(at)digitalfairway(dot)com> |
---|---|
To: | Thomas Hallgren <thomas(at)tada(dot)se> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Gevik Babakhani <pgdev(at)xs4all(dot)nl> |
Subject: | Re: Proposal for GUID datatype |
Date: | 2006-09-11 15:22:28 |
Message-ID: | 200609111122.28439.jdevisser@digitalfairway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Monday 11 September 2006 11:05, Thomas Hallgren wrote:
> 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.
OK, good info, and something I was missing/didn't know. Apparently there is a
JDK1.5 class that does "the right thing".
>
> Kind Regards,
> Thomas Hallgren
Crawling back under my rock,
jan
--
--------------------------------------------------------------
Jan de Visser jdevisser(at)digitalfairway(dot)com
Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-09-11 15:23:44 | Re: contrib/xml2 and PG_MODULE_MAGIC |
Previous Message | Mark Wong | 2006-09-11 15:20:35 | Re: Lock partitions |