On Wed, Dec 21, 2011 at 15:24, salah jubeh <s_jubeh@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
