salah jubeh <s_jubeh(at)yahoo(dot)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