Re: Opinion wanted on UUID/GUID datatype output formats.

From: Gevik Babakhani <pgdev(at)xs4all(dot)nl>
To: Tom Dunstan <pgsql(at)tomd(dot)cc>
Cc: "Jim C(dot) Nasby" <jimn(at)enterprisedb(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Opinion wanted on UUID/GUID datatype output formats.
Date: 2006-09-20 13:01:41
Message-ID: 1158757302.22092.31.camel@voyager.truesoftware.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthew T. O'Connor 2006-09-20 13:04:21 Re: pdfs of the conference
Previous Message Zdenek Kotala 2006-09-20 12:56:23 Re: guc comment changes (was Re: Getting a move on for 8.2