Received: from tnt.diff.org ([62.98.98.6]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBVF1RL81867 for ; Sun, 31 Dec 2000 10:01:39 -0500 (EST) (envelope-from nonsolosoft@diff.org) Received: (from fer@localhost) by tnt.diff.org (8.11.1/8.9.3) id eBVEtCt11654; Sun, 31 Dec 2000 15:55:12 +0100 (CET) (envelope-from nonsolosoft@diff.org) Date: Sun, 31 Dec 2000 15:55:12 +0100 (CET) Message-Id: <200012311455.eBVEtCt11654@tnt.diff.org> X-Authentication-Warning: tnt.diff.org: fer set sender to nonsolosoft@diff.org using -f From: Ferruccio Zamuner To: pgsql-sql@postgresql.org Subject: Unable to identify an ordering operator X-Archive-Number: 200012/318 X-Sequence-Number: 658 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