Re: can not use the column after rename

[Simon Tokumine <simon@xxxxxxxxxxxxxx>]

Hi Salah,

This is equivalent:

WITH numbers AS (SELECT 1 AS a, 2 AS b) SELECT a, b, a+b AS c FROM numbers;

S

On Wed, Dec 21, 2011 at 11:39 AM, salah jubeh <s_jubeh@xxxxxxxxx> wrote:

Hello,

Why I can not do something like this in Postgres.

 SELECT 1 as a , 2 as b , a + b as c ;

Regards