Re: PG7.4 ordering operator - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PG7.4 ordering operator
Date
Msg-id 1621.1069307996@sss.pgh.pa.us
Whole thread Raw
In response to PG7.4 ordering operator  (strk <strk@keybit.net>)
Responses Re: PG7.4 ordering operator  (strk <strk@keybit.net>)
List pgsql-hackers
strk <strk@keybit.net> writes:
> Testing postgis support in PG7.4 (2003-11-11)
> I've encountered to this problem:
>         ERROR:  could not identify an ordering operator for type geometry
> Previous PG versions does not show this problem.
> Any hint on what might be missing ?

A default btree operator class for type geometry.  PG 7.4 no longer
uses assumptions about operator names to determine sorting/grouping
behavior.  If you have some operators that provide a scalar sort
ordering on your datatype, then make a btree opclass to show that.
See
http://www.postgresql.org/docs/7.4/static/xindex.html#XINDEX-OPCLASS-DEPENDENCIES
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [pgsql-advocacy] Not 7.5, but 8.0 ?
Next
From: Shridhar Daithankar
Date:
Subject: Re: RPM building fun