Jan de Visser wrote: > On Saturday 09 September 2006 00:42, [EMAIL PROTECTED] wrote: > > But if the input isn't 32 hexadecimal characters - I don't see how > > it fits the UUID/GUID type. > > Again, it wasn't about that particular *value* (which, as I concurred, is not > a [GU]UID). It was about the fact that different tools spit out stuff in > different formats, and that it would suck royally if you would have to > convert because Gevik didn't think of the particular format of your > particular tool. > > But I guess your suggestion of just ignoring punctuation would work just fine.
Would it? The output you showed was 3b732da7:10d9029b3eb:-8000 What to do with the :-8000 part? Do you discard the whole :-8000? Do you discard the :- and keep the 8000? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq