Re: order by, for custom types - Mailing list pgsql-hackers

From Tom Lane
Subject Re: order by, for custom types
Date
Msg-id 11210.1132670749@sss.pgh.pa.us
Whole thread Raw
In response to Re: order by, for custom types  ("Kevin McArthur" <Kevin@StormTide.ca>)
Responses Re: order by, for custom types
List pgsql-hackers
"Kevin McArthur" <Kevin@StormTide.ca> writes:
> This is acceptable to create a unique constraint, however, we cannot mark 
> the column unique, without defining btree operators, which clearly are not 
> possible for sorting. Is there any way to base the operators based on the 
> text representation of the type for strict equality (not to be confused with 
> same or equivilent) and thus use that not as an ordering method, but as a 
> simple equality for uniqueness.

Translation: you do know how to define a sortable order (ie, generate
the text version and compare); you're just too lazy to create the
operators to do it ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin McArthur"
Date:
Subject: Re: order by, for custom types
Next
From: Tom Lane
Date:
Subject: Re: Practical error logging for very large COPY