Re: Proposal for GUID datatype

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

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

--
--------------------------------------------------------------
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 mark 2006-09-09 01:34:34 Re: Proposal for GUID datatype
Previous Message elein 2006-09-08 23:44:49 Re: Domains and subtypes, a brief proposal