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
I think it might fall into something like (untested):
select * from (select a, (...) as subsel from taba) as foo
to fit standard, but that's pretty ugly...
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2001-08-24 20:56:44|
|Subject: Re: WHERE on an alias |
|Previous:||From: Josh Berkus||Date: 2001-08-24 20:43:21|
|Subject: Re: WHERE on an alias|