Unable to identify an ordering operator

Поиск
Список
Период
Сортировка
От Ferruccio Zamuner
Тема Unable to identify an ordering operator
Дата
Msg-id 200012311455.eBVEtCt11654@tnt.diff.org
обсуждение исходный текст
Ответы Re: Unable to identify an ordering operator  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Hello,

select persons.name,firm.name,persons.tel      from persons,work,firm       where (persons.table_owner=0) and
 (work.id_firm=firm.id and work.id_person=persons.id)          union  select persons.name,firm.name,persons.tel
from persons,work,firm          where (persons.table_owner=1) and                (work.id_firm=firm.id and
work.id_person=persons.id);

ERROR:  Unable to identify an ordering operator '<' for type '_text'       Use an explicit ordering operator or modify
thequery
 


I know that this query can be rewrite to eliminate the UNION using an
OR operator on first condition but my question is:

How can I specify an ordering operator? On which field have I to put it?


Best wishes for the new YEAR,              \fer


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Rules
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Unable to identify an ordering operator