Re: can not use the column after rename - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: can not use the column after rename
Date
Msg-id CABRT9RAhhH=ThhxCD+=8yU-Qpdu0VSFcDHO-2JtWtWmt9aJ41Q@mail.gmail.com
Whole thread Raw
In response to Re: can not use the column after rename  (salah jubeh <s_jubeh@yahoo.com>)
List pgsql-general
On Wed, Dec 21, 2011 at 15:24, salah jubeh <s_jubeh@yahoo.com> wrote:
> Why I can not use it directly  as shown in the example below.
> why a and b can not be used as aliases for the column names ? I want to know
> the theoretical reason behind it?

As far as I know, that's how the SQL standard specifies it. PostgreSQL
is pretty strict about following the SQL standard. Diverging from the
standard in this aspect would cause ambiguities.

Regards,
Marti

pgsql-general by date:

Previous
From: Jacques Lamothe
Date:
Subject: Cannot connect to 2nd cluster database remotely
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: Cannot connect to 2nd cluster database remotely