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

2006-08-09 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> 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 synt

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

2006-08-09 Thread David Fetter
On Wed, Aug 09, 2006 at 03:05:02PM +0200, Peter Eisentraut wrote: > Am Freitag, 4. August 2006 04:50 schrieb Tom Lane: > > I'd like to see us refactor the docs as necessary to reflect that > > idea. Peter is right that this needs some discussion in > > syntax.sgml as well as in the reference pages

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

2006-08-09 Thread Peter Eisentraut
Am Freitag, 4. August 2006 04:50 schrieb Tom Lane: > I'd like to see us refactor the docs as necessary to reflect that idea. > Peter is right that this needs some discussion in syntax.sgml as well as > in the reference pages --- but I'm still not very clear on how the > presentation should go. I'm

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

2006-08-03 Thread Tom Lane
Gavin Sherry <[EMAIL PROTECTED]> writes: > On Fri, 4 Aug 2006, Michael Glaesemann wrote: >> On Aug 3, 2006, at 23:58 , Tom Lane wrote: >>> Should we give VALUES its own reference page? That doesn't quite >>> seem helpful either. >> >> I think we should go for a separate reference page, as VALUES