Re: UUID/GUID discussion leading to request for hexstring bytea?

Поиск
Список
Период
Сортировка
От Thomas Hallgren
Тема Re: UUID/GUID discussion leading to request for hexstring bytea?
Дата
Msg-id 450EC808.20708@tada.se
обсуждение исходный текст
Ответ на Re: UUID/GUID discussion leading to request for hexstring bytea?  (mark@mark.mielke.cc)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] Patch for UUID datatype (beta)
Следующее
От: mark@mark.mielke.cc
Дата:
Сообщение: Re: [PATCHES] Patch for UUID datatype (beta)