Re: UUID/GUID discussion leading to request for hexstring bytea? - Mailing list pgsql-hackers

From Thomas Hallgren
Subject Re: UUID/GUID discussion leading to request for hexstring bytea?
Date
Msg-id 450E5395.4080106@tada.se
Whole thread Raw
In response to Re: UUID/GUID discussion leading to request for hexstring bytea?  (Gevik Babakhani <pgdev@xs4all.nl>)
Responses Re: UUID/GUID discussion leading to request for hexstring bytea?  (Gevik Babakhani <pgdev@xs4all.nl>)
List 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



pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Release notes
Next
From: Thomas Hallgren
Date:
Subject: Re: TODO item: GUID