PG7.4 ordering operator

Поиск
Список
Период
Сортировка
От strk
Тема PG7.4 ordering operator
Дата
Msg-id 20031119114416.A68027@freek.keybit.net
обсуждение исходный текст
Ответы Re: PG7.4 ordering operator
Список 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
ormodify 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=#
selectthe_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;


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Win32 port
Следующее
От: Sailesh Krishnamurthy
Дата:
Сообщение: Re: Is there going to be a port to Solaris 9 x86 in the