Re: Mandatory AS keyword in SELECT statements - Mailing list pgsql-general

Martijn van Oosterhout wrote:
-- Start of PGP signed section.
> On Fri, Jan 04, 2008 at 09:31:41AM -0500, Bruce Momjian wrote:
> > Unfortunately, this is on our TODO list as something we are not planning
> > to do:
> >
> >     * Allow AS in "SELECT col AS label" to be optional (not wanted)
> >
> >       Because we support postfix operators, it isn't possible to make AS
> >       optional and continue to use bison.
>
> For reference, the problematic examples are:
>
> SELECT a + b;   -- Is this (a +) aliased to "b", or (a+b) with no alias
> SELECT 'foo'::character varying -- Is "varying" an alias or part of the type name?
>
> See this thread:
> http://archives.postgresql.org/pgsql-hackers/2003-04/msg00436.php

Interesting.  I have added that URL to the TODO list.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +