Re: Proposal for GUID datatype

From: Jan de Visser <jdevisser(at)digitalfairway(dot)com>
To: mark(at)mark(dot)mielke(dot)cc
Cc: pgsql-hackers(at)postgresql(dot)org, Gevik Babakhani <pgdev(at)xs4all(dot)nl>
Subject: Re: Proposal for GUID datatype
Date: 2006-09-09 02:49:21
Message-ID: 200609082249.21914.jdevisser@digitalfairway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Friday 08 September 2006 21:34, mark(at)mark(dot)mielke(dot)cc wrote:
> On Fri, Sep 08, 2006 at 09:24:19PM -0400, 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 %
>
> That doesn't look like a UUID/GUID - unless it trims leading zeroes?
>
> UUID/GUID = 128-bits = 32 hexadecimal characters.

I know, it's a UID. Not a GUID. But many people (including myself) use it as a
base to generate GUIDs. And that's not really the point. The point is that
I'm afraid he's going to restrict himself to much.

>
> Cheers,
> mark

jan

--
--------------------------------------------------------------
Jan de Visser                     jdevisser(at)digitalfairway(dot)com

                Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-09-09 03:18:07 Re: [HACKERS] Fix linking of OpenLDAP libraries
Previous Message Merlin Moncure 2006-09-09 02:22:19 Re: Build v8.1.4 with VC++ 2005