Re: Proposal for GUID datatype
От | Jan de Visser |
---|---|
Тема | Re: Proposal for GUID datatype |
Дата | |
Msg-id | 200609111122.28439.jdevisser@digitalfairway.com обсуждение исходный текст |
Ответ на | Re: Proposal for GUID datatype (Thomas Hallgren <thomas@tada.se>) |
Список | 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@pat.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@digitalfairway.com Baruk Khazad! Khazad ai-menu! --------------------------------------------------------------
В списке pgsql-hackers по дате отправления: