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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Gevik Babakhani <pgdev(at)xs4all(dot)nl>
Subject: Re: Opinion wanted on UUID/GUID datatype output formats.
Date: 2006-09-14 21:32:09
Message-ID: 200609142332.10318.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2006-09-14 21:32:56 Re: Mid cycle release?
Previous Message Bruce Momjian 2006-09-14 21:25:47 Re: Draft release notes