X-Original-To: pgsql-hackers-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 256AD9FA0EC
	for <pgsql-hackers-postgresql.org@postgresql.org>;
	Mon, 17 Jul 2006 18:42:26 -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 66032-08 for
	<pgsql-hackers-postgresql.org@postgresql.org>;
	Mon, 17 Jul 2006 18:42:12 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from joeconway.com (wsip-68-15-9-201.sd.sd.cox.net [68.15.9.201])
	by postgresql.org (Postfix) with ESMTP id 54BD69FA0B9
	for <pgsql-hackers@postgresql.org>;
	Mon, 17 Jul 2006 18:42:12 -0300 (ADT)
Received: from [206.190.70.130] (account jconway HELO [172.16.1.115])
	by joeconway.com (CommuniGate Pro SMTP 4.1.8)
	with ESMTP-TLS id 4052937; Mon, 17 Jul 2006 14:42:10 -0700
Message-ID: <44BC0432.3040509@joeconway.com>
Date: Mon, 17 Jul 2006 14:42:10 -0700
From: Joe Conway <mail@joeconway.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.7.13) Gecko/20060501 Fedora/1.7.13-1.1.fc5
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Andrew Dunstan <andrew@dunslane.net>
CC: Bernd Helmle <mailings@oopsware.de>, Peter Eisentraut <peter_e@gmx.net>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>,
	Susanne Ebrecht <susanne.ebrecht@credativ.de>
Subject: Re: 8.2 features?
References: <44B69778.5050104@dunslane.net>
	<50461.84.63.113.55.1152832991.squirrel@pezone.net>
	<ECCAAC0A3182895D3D12B0E8@[172.26.14.247]>
	<44B7ADFC.90205@dunslane.net>
In-Reply-To: <44B7ADFC.90205@dunslane.net>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200607/672
X-Sequence-Number: 86527

Andrew Dunstan wrote:
> Bernd Helmle wrote:
>>
>> --On Freitag, Juli 14, 2006 01:23:11 +0200 Peter Eisentraut 
>> <peter_e@gmx.net> wrote:
>>
>>>> . multiple values clauses for INSERT
>>>
>>> Susanne Ebrecht <susanne.ebrecht@credativ.de> was last heard to work on
>>> it.  Updates, Susanne?
>>
>> I've talked to Susanne today and she's just back from hospital and not 
>> available online until next week.
>> She was working on the SET (col1, col2) = (val1, val2) syntax for 
>> UPDATE commands.
>> Don't know what the status is on this, though.
> 
> Not the same thing, surely. So maybe we should gratefully accept Joe 
> Conway's offer to work on it.

I've played with this a bit now, and the grammar changes seem pretty 
straightforward, but the other half is kind of ugly. I can't see a good 
way to propagate multiple targetlists that isn't a big hack.

The best way might be to fabricate a selectStmt equiv to
"SELECT <targetlist> UNION ALL SELECT <targetlist>...",
but that still feels like a hack.

Have there been any past discussions on how this might be implemented 
(FWIW I couldn't find any in the archives)? Any better ideas for an 
approach?

Thanks,

Joe