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