Re: Simple SQL - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Simple SQL
Date
Msg-id Pine.LNX.4.44.0310240725050.9738-100000@kix.fsv.cvut.cz
Whole thread Raw
In response to Simple SQL  (Bob Messenger <bob@cassiancapital.com>)
Responses Re: Simple SQL  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
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
>


pgsql-general by date:

Previous
From: Scott Chapman
Date:
Subject: Re: HTML generation with PL/PgSQL
Next
From: Nagib Abi Fadel
Date:
Subject: ERROR: Multiple assignments to same attribute... ??