Search Postgresql Archives

Re: Mandatory AS keyword in SELECT statements

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux