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

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)