Added to TODO:
* Allow the UUID type to accept non-standard formats
http://archives.postgresql.org/pgsql-hackers/2008-02/msg01214.php
---------------------------------------------------------------------------
Dawid Kuroczko wrote:
> Hello.
>
> I am currently playing with UUID data type and try to use it to store provided
> by third party (Hewlett-Packard) application. The problem is they
> format UUIDs as
> 0000-0000-0000-0000-0000-0000-0000-0000, so I have to
> replace(text,'-','')::uuid for
> this kind of data.
>
> Nooow, the case is quite simple and it might be that there are other
> applications
> formatting UUIDs too liberally.
>
> I am working on a patch to support this format (yes, it is a simple
> modification).
>
> And in the meanwhile I would like to ask you what do you think about it?
>
> Cons: Such format is not standard.
>
> Pros: This will help UUID data type adoption. [1] While good
> applications format
> their data well, there are others which don't follow standards. Also
> I think it is
> easier for a human being to enter UUID as 8 times 4 digits.
>
> Your thoughts? Should I submit a patch?
>
> Regards,
> Dawid
>
> [1]: My first thought when I received the error message was "hey! this
> is not an UUID,
> it is too long/too short!", only later did I check that they just
> don't format it too well.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +