Re: can not use the column after rename

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: salah jubeh <s_jubeh(at)yahoo(dot)com>
Cc: Simon Tokumine <simon(at)vizzuality(dot)com>, pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: can not use the column after rename
Date: 2011-12-21 13:37:50
Message-ID: CABRT9RAhhH=ThhxCD+=8yU-Qpdu0VSFcDHO-2JtWtWmt9aJ41Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 21, 2011 at 15:24, salah jubeh <s_jubeh(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2011-12-21 13:52:02 Re: Cannot connect to 2nd cluster database remotely
Previous Message Jacques Lamothe 2011-12-21 13:26:40 Cannot connect to 2nd cluster database remotely