PG7.4 ordering operator

From: strk <strk(at)keybit(dot)net>
To: postgis-devel(at)postgis(dot)refractions(dot)net
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: PG7.4 ordering operator
Date: 2003-11-19 10:44:16
Message-ID: 20031119114416.A68027@freek.keybit.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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
HINT: Use an explicit ordering operator or modify the query.

Whenever I issue one of these commands:

gis=# select the_geom from table1 UNION select the_geom from table2;
gis=# select DISTINCT the_geom from table1;
gis=# select the_geom from table1 ORDER BY the_geom;

Operators '<', '>', '=' are available:

oprname | leftoperand | rightoperand
---------+-------------+--------------
<< | geometry | geometry
&< | geometry | geometry
&& | geometry | geometry
&> | geometry | geometry
>> | geometry | geometry
~= | geometry | geometry
@ | geometry | geometry
~ | geometry | geometry
= | geometry | geometry
< | geometry | geometry
> | geometry | geometry
(11 rows)

Previous PG versions does not show this problem.
Any hint on what might be missing ?

--strk;

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Lee Kindness 2003-11-19 11:02:59 ECPG: "EXEC SQL CREATE SCHEMA foo" Broken
Previous Message Shridhar Daithankar 2003-11-19 10:29:31 Re: Win32 port