On Tue, 3 Jul 2001, Peter Eisentraut wrote:
>> Dmitry's stuff contains both datatype (uniqueidentifier), a function to
>> generate a new object of that type (newid), and a set of functions to
>> implement comparison operators for that type.
> It would be much simpler if you stored the unique id in varchar or text.
UUIDs have specific rules for comparison of them. Its so much easier to
compare them via a<b than uuid_lt(a,b). If one wanted to make a meaningful
index on uuid value, normal ordering of varchar would not suffice...
In response to
pgsql-hackers by date
|Next:||From: Martín Marqués||Date: 2001-07-03 16:30:12|
|Subject: Re: [OT] Any major users of postgresql?|
|Previous:||From: Alex Pilosov||Date: 2001-07-03 15:37:20|
|Subject: Re: New data type: uniqueidentifier|