From: Bruce Momjian <bruce@momjian.us>
To: Michael Glaesemann <grzm@seespotcode.net>
Cc: Joe Conway <mail@joeconway.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Hackers (PostgreSQL) <pgsql-hackers@postgresql.org>
Subject: Re: Values list-of-targetlists patch for comments (was Re:
Date: Wed, 2 Aug 2006 09:30:29 -0400 (EDT)
Message-ID: <200608021330.k72DUTp09254@momjian.us> (raw)
In-Reply-To: <1CD9D95B-E824-4A0D-85BB-279AD06B931C@seespotcode.net>
Michael Glaesemann wrote:
> On Aug 2, 2006, at 12:47 , Joe Conway wrote:
>
>
> > regression=# create rule r2 as on update to src do insert into log
> > values(old.*, 'old'), (new.*, 'new');
> > ERROR: VALUES must not contain OLD or NEW references
> >
>
> Would it make sense to add a HINT as well, recommending the UNION
> construct Tom mentioned earlier?
Agreed.
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
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: bruce@momjian.us, grzm@seespotcode.net, mail@joeconway.com, tgl@sss.pgh.pa.us, pgsql-hackers@postgresql.org
Subject: Re: Values list-of-targetlists patch for comments (was Re:
In-Reply-To: <200608021330.k72DUTp09254@momjian.us>
* 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