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
