Jan de Visser wrote:
> On Saturday 09 September 2006 00:42, mark@mark.mielke.cc 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.