Re: [HACKERS] [PATCHES] Values list-of-targetlists patch for comments (was Re:

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

David Fetter <david(at)fetter(dot)org> writes:
> However, there are some oddities:
> postgres=# SELECT * FROM (VALUES (1,2)) AS foo(bar,baz);
> [ works ]
> postgres=# (VALUES (1,2)) AS foo(bar,baz);
> ERROR:  syntax error at or near "AS"

This is per spec.  Effectively, AS is part of the FROM-clause syntax
not part of a standalone command.  You can't write this either:

regression=# (select 1,2) as foo(bar,baz);
ERROR:  syntax error at or near "as"
LINE 1: (select 1,2) as foo(bar,baz);
                     ^

			regards, tom lane