From: | Gevik Babakhani <pgdev(at)xs4all(dot)nl> |
---|---|
To: | Thomas Hallgren <thomas(at)tada(dot)se> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: UUID/GUID discussion leading to request for hexstring bytea? |
Date: | 2006-09-18 08:46:00 |
Message-ID: | 1158569160.19958.18.camel@voyager.truesoftware.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
LIKE could come handy if someone wants to abuse the uuid datatype to
store MD5 hash values. However I am not going to implement it if there
is no need for that (assuming it will pass the acceptance test)
On Mon, 2006-09-18 at 10:06 +0200, Thomas Hallgren wrote:
> Gevik Babakhani wrote:
> > To my opinion GUIDs type need to provide the following in the database.
> >
> > 1. GUID type must accept the correct string format(s), with of without
> > extra '-'
> > 2. GUID type must internally be stored as small as possible.
> > 3. GUID type must be comparable with == , != , LIKE and (NOT) IS NULL
> > 4. GUID type must have the ability to be indexed, grouped, ordered,
> > DISTINCT... but not MAX(), MIN() or SUM()....
> >
> Where do you see a need for LIKE on a GUID?
>
> Regards,
> Thomas Hallgren
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Hallgren | 2006-09-18 08:59:11 | Re: UUID/GUID discussion leading to request for hexstring bytea? |
Previous Message | Gevik Babakhani | 2006-09-18 08:41:38 | Re: Patch for UUID datatype (beta) |