X-Original-To: pgsql-docs-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 31D389FB2EC
	for <pgsql-docs-postgresql.org@postgresql.org>;
	Fri,  4 Aug 2006 04:02:15 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 18868-05 for <pgsql-docs-postgresql.org@postgresql.org>;
	Fri,  4 Aug 2006 04:02:14 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by postgresql.org (Postfix) with SMTP id D8A5F9FB2DD
	for <pgsql-docs@postgresql.org>; Fri,  4 Aug 2006 04:02:13 -0300 (ADT)
Received: (qmail invoked by alias); 04 Aug 2006 07:02:12 -0000
Received: from dslb-084-063-123-208.pools.arcor-ip.net (EHLO colt.pezone.net)
	[84.63.123.208]
	by mail.gmx.net (mp037) with SMTP; 04 Aug 2006 09:02:12 +0200
X-Authenticated: #495269
From: Peter Eisentraut <peter_e@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Values list-of-targetlists patch for comments (was Re: [PATCHES]
Date: Fri, 4 Aug 2006 09:02:09 +0200
User-Agent: KMail/1.9.1
Cc: Gavin Sherry <swm@linuxworld.com.au>, pgsql-docs@postgresql.org,
	Joe Conway <mail@joeconway.com>
References: <44B69778.5050104@dunslane.net>
	<200608040321.48560.peter_e@gmx.net> <860.1154658983@sss.pgh.pa.us>
In-Reply-To: <860.1154658983@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200608040902.09945.peter_e@gmx.net>
X-Y-GMX-Trusted: 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200608/11
X-Sequence-Number: 3629

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/