X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 95B21924CD5 for ; Sat, 17 May 2003 12:39:49 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 55060-02 for ; Sat, 17 May 2003 12:39:48 -0400 (EDT) Received: from technovell.com (213-97-10-232.uc.nombres.ttd.es [213.97.10.232]) by developer.postgresql.org (Postfix) with ESMTP id 866C3924CD4 for ; Sat, 17 May 2003 12:39:47 -0400 (EDT) Received: from pgsql [192.168.1.200] by technovell.com with NetMail ModWeb Module; Sat, 17 May 2003 18:40:01 +0200 Subject: COALESCE in ORDER BY... From: "Terry Yapt" To: pgsql-sql@postgresql.org Date: Sat, 17 May 2003 18:40:01 +0200 X-Mailer: NetMail ModWeb Module X-Sender: pgsql MIME-Version: 1.0 Message-ID: <1053189601.81a4c98pgsql@technovell.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/361 X-Sequence-Number: 13526 Why this doesn't run on postrgreSQL 7.3.1 ? www=3D> SELECT 10 AS first ORDER BY first DESC;=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 first ------- 10 (1 row) www=3D> SELECT 10 AS first ORDER BY COALESCE(first,0) DESC; ERROR: Attribute "first" not found Thanks in advance..