Postgres Pro
Downloads
Home   >   mailing lists

Re: How to deal with order by, group by, distinct for user-defined types - Mailing list pgsql-hackers

From Tom Lane
Subject Re: How to deal with order by, group by, distinct for user-defined types
Date
Msg-id 5732.1101024878@sss.pgh.pa.us
Whole thread Raw
In response to How to deal with order by, group by, distinct for user-defined types  (Ruey-Lung Hsiao <rlhsiao@gmail.com>)
List pgsql-hackers
Tree view 
Ruey-Lung Hsiao <rlhsiao@gmail.com> writes:
>    My question is: how do I find or define ordering operators for my 
> user-defined type?

Create a default btree index operator class for the type.  See
http://developer.postgresql.org/docs/postgres/xindex.html
        regards, tom lane

pgsql-hackers by date:

Previous
From: Ruey-Lung Hsiao
Date:
Subject: How to deal with order by, group by, distinct for user-defined types
Next
From: Thomas Hallgren
Date:
Subject: Re: Error handling in plperl and pltcl