Skip site navigation (1) Skip section navigation (2)

Re: Re: New data type: uniqueidentifier

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: "Dmitry G(dot) Mastrukov" <dmitry(at)taurussoft(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: New data type: uniqueidentifier
Date: 2001-07-03 15:52:31
Message-ID: Pine.BSO.4.10.10107031147590.2882-100000@spider.pilosoft.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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



In response to

pgsql-hackers by date

Next:From: Martín MarquésDate: 2001-07-03 16:30:12
Subject: Re: [OT] Any major users of postgresql?
Previous:From: Alex PilosovDate: 2001-07-03 15:37:20
Subject: Re: New data type: uniqueidentifier

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group