Re: can not use the column after rename

From: Simon Tokumine <simon(at)vizzuality(dot)com>
To: salah jubeh <s_jubeh(at)yahoo(dot)com>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: can not use the column after rename
Date: 2011-12-21 12:14:52
Message-ID: CAErctvJ93zqYGHOPD5dpAfvYDVx0svMgfFQ9WtE4fkXzWtwedA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)yahoo(dot)com> wrote:

> Hello,
>
> Why I can not do something like this in Postgres.
>
> SELECT 1 as a , 2 as b , a + b as c ;
>
> Regards
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message salah jubeh 2011-12-21 13:24:11 Re: can not use the column after rename
Previous Message salah jubeh 2011-12-21 11:39:03 can not use the column after rename