| 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: | Whole Thread | Raw Message | 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 |