On Fri, Oct 24, 2003 at 07:25:44AM +0200, Pavel Stehule wrote:
Not
SELECT 1 as a, a*2;
ERROR: column "a" does not exist
But you can try
SELECT a, a*a FROM (select 1 as a);
On Tue, 21 Oct 2003, Bob Messenger wrote:
Is it possible to do something like:
select 1 as a, a*a;
in postgres?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Hay que recordar que la existencia en el cosmos, y particularmente la
elaboración de civilizaciones dentre de él no son, por desgracia,
nada idílicas" (Ijon Tichy)
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend