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

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.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/