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