| From: | Ferruccio Zamuner <nonsolosoft(at)diff(dot)org> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Unable to identify an ordering operator |
| Date: | 2000-12-31 14:55:12 |
| Message-ID: | 200012311455.eBVEtCt11654@tnt.diff.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 the query
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-12-31 17:17:19 | Re: Unable to identify an ordering operator |
| Previous Message | Peter Eisentraut | 2000-12-31 12:18:30 | Re: Rules |