Re: Values list-of-targetlists patch for comments (was Re: [PATCHES] - Mailing list pgsql-docs

From Peter Eisentraut
Subject Re: Values list-of-targetlists patch for comments (was Re: [PATCHES]
Date
Msg-id 200608040902.09945.peter_e@gmx.net
Whole thread Raw
In response to Re: Values list-of-targetlists patch for comments (was Re: [PATCHES]  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-docs
Tom Lane wrote:
> Wrong question.  SELECT (for the general case of multi-row results)
> and VALUES are exactly parallel in the SQL grammar; the right
> question is "according to what theory are you allowed to issue a
> general SELECT?"

The "top-level" SELECT for interactive use is

<direct SQL statement> ::= <directly executable statement> <semicolon>

<directly executable statement> ::= <direct SQL data statement> | ...

<direct SQL data statement> ::= <direct select statement: multiple rows> | ...

But this actually does resolve as just VALUES (something), so nevermind.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] Values list-of-targetlists patch for comments (was Re:
Next
From: Simon Riggs
Date:
Subject: Re: Values list-of-targetlists patch for comments (was Re: