Re: Re: New data type: uniqueidentifier

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.
Peter,

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...

-alex