Re: Mandatory AS keyword in SELECT statements

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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

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