Re: UUID/GUID discussion leading to request for hexstring bytea?

From: Thomas Hallgren <thomas(at)tada(dot)se>
To: Gevik Babakhani <pgdev(at)xs4all(dot)nl>
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:06:45
Message-ID: 450E5395.4080106@tada.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2006-09-18 08:21:23 Re: Release notes
Previous Message Thomas Hallgren 2006-09-18 08:01:54 Re: TODO item: GUID