Re: [GENERAL] Change UUID type default output representation

2015-05-28 Thread Peter Eisentraut
On 5/28/15 5:35 PM, Randall Lucas wrote: > Can I compile my own version of uuid_out and update the system > catalogs, or create a "uuid_dashless" type that uses my own custom > uuid_dashless.c that's hacked to remove dashes? Either one would work. -- Sent via pgsql-general mailing list (pgsql-

[GENERAL] Change UUID type default output representation

2015-05-28 Thread Randall Lucas
I have been using UUIDs for PKs to allow me the flexibility of generating PKs within PostgreSQL or at the application code level. However, I have been storing them as CHAR(32) in the hex string representation (no dashes) in order to simplify comparisons and manipulations at a very practical level.