On Thu, 2006-09-07 at 14:46 +0200, Martijn van Oosterhout wrote: > 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... >
Yes indeed, I just want to address that guid > guid or any other operation like that has no meaning. > > 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? Yes, I/O format as part of the datatype and not a separate function. > > Have a nice day, > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend