Re: UUID/GUID discussion leading to request for hexstring bytea? - Mailing list pgsql-hackers

From Thomas Hallgren
Subject Re: UUID/GUID discussion leading to request for hexstring bytea?
Date
Msg-id 450EC808.20708@tada.se
Whole thread Raw
In response to Re: UUID/GUID discussion leading to request for hexstring bytea?  (mark@mark.mielke.cc)
List pgsql-hackers
mark@mark.mielke.cc wrote:
> On Mon, Sep 18, 2006 at 11:12:54AM +0200, Gevik Babakhani wrote:
>>> Magnitude comparison on the GUID as a whole makes no 
>>> sense to me.
>> I agree. Any kind of comparison except equality has no meaning for the
>> GUID. (And this is discussed before) I rather have the option to sort
>> and group for the sake of consistency and compatibility.
> 
> Thomas: The ability to sort / comparison is required for use with
> B-Tree index. I prefer a fast comparison over one with more meaning.
> memcmp() is fine with me and it is how I implement it in my UUID
> PostgreSQL library.
> 
Fair enough. Although the magnitudes as such makes little sense, the ability to order will 
make it possible to compare results from different queries etc. Very difficult to do with 
random order.

Regards,
Thomas Hallgren



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] Patch for UUID datatype (beta)
Next
From: mark@mark.mielke.cc
Date:
Subject: Re: [PATCHES] Patch for UUID datatype (beta)