Re: Proposal for GUID datatype

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.