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

From Jim C. Nasby
Subject Re: Opinion wanted on UUID/GUID datatype output formats.
Date
Msg-id 20060916233733.GJ38854@enterprisedb.com
Whole thread Raw
In response to Re: Opinion wanted on UUID/GUID datatype output formats.  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Opinion wanted on UUID/GUID datatype output formats.  (Tom Dunstan <pgsql@tomd.cc>)
List pgsql-hackers
On Thu, Sep 14, 2006 at 11:32:09PM +0200, Peter Eisentraut wrote:
> Gevik Babakhani wrote:
> > As suggested in earlier discussion we provide a raw/plain output of
> > the uuid type:
> >
> > devdb=# select * from tbluuid;
> >                 pk                |
> > ----------------------------------+
> >  6b13c5a1afb4dcf5ce8f8b4656b6c93c |
> >  01e40a79b55b6e226bffb577e960453d |
> > (2 rows)
> 
> The UUID standards define a single perfectly clear format, and the one 
> you show is not it.
> 
> > I was wondering if we want to have a formatting function to be able
> > to provide other common formats of the uuid/guid?
> 
> If you stick to the standard format, I don't think that will be 
> necessary.

+1. For people that care about the non-standard MSSQL format, they can
easily create their own function that will wrap it in {}.
-- 
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: New version of money type
Next
From: Gevik Babakhani
Date:
Subject: Opinion about macro for the uuid datatype.