pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Eisentraut <peter_e@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Gavin Sherry <swm@linuxworld.com.au>
Cc: pgsql-docs@postgresql.org, Joe Conway <mail@joeconway.com>
Subject: Re: Values list-of-targetlists patch for comments (was Re: [PATCHES]
Date: Fri, 4 Aug 2006 09:02:09 +0200
Message-ID: <200608040902.09945.peter_e@gmx.net> (raw)
In-Reply-To: <860.1154658983@sss.pgh.pa.us>
References: <44B69778.5050104@dunslane.net>
	<200608040321.48560.peter_e@gmx.net>
	<860.1154658983@sss.pgh.pa.us>

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/



view thread (61+ messages)  latest in thread

Message-ID: <200608040902.09945.peter_e@gmx.net>
Permalink:  ../200608040902.09945.peter_e@gmx.net/
Also on:    postgresql.org/message-id/200608040902.09945.peter_e@gmx.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: peter_e@gmx.net, tgl@sss.pgh.pa.us, swm@linuxworld.com.au, mail@joeconway.com
  Subject: Re: Values list-of-targetlists patch for comments (was Re: [PATCHES]
  In-Reply-To: <200608040902.09945.peter_e@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox