Received: from danbo.digsys.bg (danbo.digsys.bg [192.92.129.10]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA40444 for ; Thu, 3 Feb 2000 09:35:17 -0500 (EST) (envelope-from vlady@lorna.digsys.bg) Received: from lorna.digsys.bg (root@lorna.digsys.bg [193.68.6.15]) by danbo.digsys.bg (8.9.0/8.9.0) with ESMTP id QAA09576 for ; Thu, 3 Feb 2000 16:34:33 +0200 (EET) Received: from lorna.digsys.bg (vlady@localhost.digsys.bg [127.0.0.1]) by lorna.digsys.bg (8.9.0/8.9.0) with ESMTP id QAA01945 for ; Thu, 3 Feb 2000 16:34:32 +0200 (EET) Message-Id: <200002031434.QAA01945@lorna.digsys.bg> X-Mailer: exmh version 2.0.2 2/24/98 To: pgsql-sql@postgresql.org From: "Vladimir Terziev" Subject: Question about SELECT and ORDER BY Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Thu, 03 Feb 2000 16:34:31 +0200 Sender: vlady@digsys.bg Hi, I have two tables: table1 (attr1 text, attr2 int4) table2 (attr1 text, attr3 int4, attr4 bool) I have a query: SELECT table1.attr1 AS ALIAS, attr2 from table1 UNION ALL SELECT table2.attr1, attr3 from table2 ORDER BY ALIAS; I that syntax all is OK. I want to have a result from ORDER BY length(ALIAS), but this is imposible. When ORDER BY clause is in format ORDER BY length(attr1), the result is not ORDERED BY length of attr1. What can I do? Are anybody have an idea? Vladimir