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;
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 |