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

On Thu, Sep 07, 2006 at 01:27:21PM +0200, Gevik Babakhani wrote:
> To my opinion only some of relational/compare operations like == and !=
> apply to such values. comparing guid >= guid or md5 < md5 is also
> meaningless.

<snip>

> 4. GUID type must have the ability to be indexed, grouped, ordered,
> DISTINCT... but not MAX(), MIN() or SUM()....

Err, for "ordered" you need to define <, >, >=, <=, which means you're
going to get MAX, and MIN for free...

> I also think we should have the GUID/UUID as a datatype and not just
> functions handling hexstring.

Sure, but that will be the I/O format, right?

Have a nice day,

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.