Re: correlated query as a column and where clause

salah jubeh <s_jubeh@yahoo.com> writes:
> But, why I can not  use the alias of the select statement ( as in the original
> post)  in the where clause.

The select list can only be computed after the where clause has filtered
the rows, so such a thing would be circular.

            regards, tom lane