From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Andreas Schmitz <andreas.schmitz@as-dataservice.de>
Cc: Terry Yapt <pgsql@technovell.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: COALESCE in ORDER BY...
Date: Sat, 17 May 2003 10:41:10 -0700 (PDT)
Message-ID: <20030517103937.K99993-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <3EC66DE1.1090705@as-dataservice.de>
On Sat, 17 May 2003, Andreas Schmitz wrote:
> Terry Yapt wrote:
>
> >www=> SELECT 10 AS first ORDER BY COALESCE(first,0) DESC;
> >ERROR: Attribute "first" not found
> >
> >Thanks in advance..
> >
> >
> Perhaps, this is a bug, but I have a workarround for you till this is
> clariefied:
Just an unimplemented enhancement I think. At least in SQL92, order
by expressions need to be column references (possibly with collation
conversions), we allow some functional order by expressions, but not one's
referencing select aliases I think.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, andreas.schmitz@as-dataservice.de, pgsql@technovell.com
Subject: Re: COALESCE in ORDER BY...
In-Reply-To: <20030517103937.K99993-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox