X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 17EA4926067 for ; Mon, 19 May 2003 18:35:12 -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 46031-08 for ; Mon, 19 May 2003 18:35:06 -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 EEB40925066 for ; Sun, 18 May 2003 07:27:32 -0400 (EDT) Received: from pgsql [192.168.1.200] by technovell.com with NetMail ModWeb Module; Sun, 18 May 2003 13:27:41 +0200 Subject: Re: COALESCE in ORDER BY... From: "Terry Yapt" To: andreas.schmitz@as-dataservice.de Cc: pgsql-sql@postgresql.org Date: Sun, 18 May 2003 13:27:41 +0200 X-Mailer: NetMail ModWeb Module X-Sender: pgsql MIME-Version: 1.0 Message-ID: <1053257261.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/369 X-Sequence-Number: 13534 Ok Thanks Andreas, but It was only curiosity because in Oracle I usually us= e this kind of ORDER BY on SQL's. Thanks... -----Original Message----- From: Andreas Schmitz To: Terry Yapt Date: Sat, 17 May 2003 19:14:09 +0200 Subject: Re: [SQL] COALESCE in ORDER BY... Terry Yapt wrote: >www=3D> SELECT 10 AS first ORDER BY COALESCE(first,0) DESC; >ERROR: Attribute "first" not found > >Thanks in advance.. >=20=20 > Perhaps, this is a bug, but I have a workarround for you till this is=20 clariefied: SELECT * FROM (SELECT 10 AS FIRST) AS vtbl ORDER BY COALESCE(vtbl.first,0) DESC; (Tested with 7.3.2) Best regards --=20 Andreas Schmitz AS-DataService Kastanienallee 24 D-54662 Speicher Tel.: (0 65 62) 93 05 17 Fax: (0 65 62) 93 05 18 Email: andreas.schmitz@as-dataservice.de=20 Ust-IdNr.: DE211466407 Handelsregister: HRA 1869 - Amtsgericht Bitburg