Peter Eisentraut wrote:

>Dmitry G. Mastrukov writes:
>
>>I've developed new data type for PostgreSQL - unique identifier - 128-bit
>>value claims to be unique across Universe. It depends on libuuid from
>>e2fsprogs by Theodore Ts'o.
>>
>
>ISTM that this should be a function, not a data type.
>
I'd second the function idea: function uuid( ) returns an int8 value; 
don't create a bazillion datatypes.  Besides, 128 bit numbers are 7 byte 
integers.   PostgreSQL has an int8 (8 byte integer) datatype.  While I 
like the UUID function idea, I'd recommend a better solution to creating 
an "unique" identifier.  Why not create a serial8 datatype: int8 with an 
int8 sequence = 256bit "unique" number.  {Yes, I know I'm violating my 
first sentence.}  Then, you'd have the same thing (or better) AND your 
not relying on randomness.  

In response to

• Re: New data type: uniqueidentifier at 2001-06-27 14:54:20 from Peter Eisentraut

Responses

• Re: Re: New data type: uniqueidentifier at 2001-07-02 18:39:23 from Alex Pilosov
• RE: Re: New data type: uniqueidentifier at 2001-07-03 01:37:33 from Christopher Kings-Lynne

pgsql-hackers by date

Next:	From: Bill Studenmund	Date: 2001-07-02 16:29:23
	Subject: Re: shared library strangeness?
Previous:	From: Lamar Owen	Date: 2001-07-02 15:50:14
	Subject: Re: Now it's my turn...