Re: Opinion wanted on UUID/GUID datatype output formats. - Mailing list pgsql-hackers

From Gevik Babakhani
Subject Re: Opinion wanted on UUID/GUID datatype output formats.
Date
Msg-id 1158757302.22092.31.camel@voyager.truesoftware.net
Whole thread Raw
In response to Re: Opinion wanted on UUID/GUID datatype output formats.  (Tom Dunstan <pgsql@tomd.cc>)
List pgsql-hackers
> The dashless format is neither standards compliant nor compatible with 
> other databases that have uuid functions (notably MS SQL Server and 
> MySQL), nor with microsoft tools where they're used frequently. 
> (ignoring the {} wrapping stuff which is trivial).
> 
> If we add a UUID type to core, I think that a vast majority of the 
> people who are going to want to use it out there will be expecting the 
> standard format with dashes. And asking them to put a formatting 
> function into every query is beyond horrific.
> 
> If we want a general raw hex type then let's call it something else, 
> because calling it UUID will just confuse people. Everyone else follows 
> the standard on this; we should too.

Agreed to all above. The formatting issues are all handled in the patch.

Regards,
Gevik




pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: guc comment changes (was Re: Getting a move on for 8.2
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: pdfs of the conference