| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martín Marqués | 2001-07-03 16:30:12 | Re: [OT] Any major users of postgresql? |
| Previous Message | Alex Pilosov | 2001-07-03 15:37:20 | Re: New data type: uniqueidentifier |