Not
SELECT 1 as a, a*2;
ERROR: column "a" does not exist
Regards
Pavel
On Tue, 21 Oct 2003, Bob Messenger wrote:
> Is it possible to do something like:
>
> select 1 as a, a*a;
>
> in postgres?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>