From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Joseph Shraibman <jks(at)selectacast(dot)net> |
Cc: | pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: WHERE on an alias |
Date: | 2001-08-24 20:52:49 |
Message-ID: | Pine.BSF.4.21.0108241343180.24006-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Fri, 24 Aug 2001, Joseph Shraibman wrote:
> That was just an example. My code doesn't use group by, it uses a subselect. And I
> checked and having doesn't work with aliases either.
Okay. I know why WHERE doesn't support aliases, but was a little confused
by the example. The reason for that is that the select list isn't
worked out until after the rows are qualified and it technically fits
spec.
I think it might fall into something like (untested):
select * from (select a, (...) as subsel from taba) as foo
where foo.subsel>5;
to fit standard, but that's pretty ugly...
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-08-24 20:56:44 | Re: WHERE on an alias |
Previous Message | Josh Berkus | 2001-08-24 20:43:21 | Re: WHERE on an alias |