Re: [SQL] Converting between UUID and VARCHAR

2008-11-28 Thread Helio Campos Mello de Andrade
Didn't you create those other tables with "character varying" too? If you did i think that you need to change those tables too. On Mon, Nov 10, 2008 at 12:44 PM, A. Kretschmer <[EMAIL PROTECTED]> wrote: > am Mon, dem 10.11.2008, um 15:34:10 +0100 mailte Mario Splivalo folgendes: >> I have a table

Re: [SQL] Converting between UUID and VARCHAR

2008-11-10 Thread A. Kretschmer
am Mon, dem 10.11.2008, um 15:34:10 +0100 mailte Mario Splivalo folgendes: > I have a table, like this: > > CREATE TABLE t1 > ( > u1 character varying > ) > > And some data inside: > > INSERT INTO t1 (u1) VALUES ('62d6b434-7dfd-4b3b-b1bf-87f6c20c10dd'); > INSERT INTO t1 (u1) VALUES ('e3fee596

[SQL] Converting between UUID and VARCHAR

2008-11-10 Thread Mario Splivalo
I have a table, like this: CREATE TABLE t1 ( u1 character varying ) And some data inside: INSERT INTO t1 (u1) VALUES ('62d6b434-7dfd-4b3b-b1bf-87f6c20c10dd'); INSERT INTO t1 (u1) VALUES ('e3fee596-164b-4995-9e0d-7b2a79e83752'); INSERT INTO t1 (u1) VALUES ('37a42ec8-9000-44bc-bb06-13b5d4373a45