[postgis-devel] PG7.4 ordering operator

strk strk at keybit.net
Wed Nov 19 02:44:16 PST 2003


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;



More information about the postgis-devel mailing list