From: Mike Meyer <mwm@mired.org>
To: pgsql-sql@postgresql.org
Subject: Rule for updating through a view.
Date: Thu, 20 Mar 2003 07:52:44 -0600
Message-ID: <15993.51116.466721.722550@guru.mired.org> (raw)
Ok, I found the documentation on using views to udpate the underlying
database. But I can't seem to get my head around making it actually
work, because updates may change only a few columns, and the columns
in my views come from multiple tables.
Could someone provide an example (CC'ing me, please, as I'm not on the
list) of setting up a rule on a joined view to udpated both the
underlying tables?
Thanks,
<mike
--
Mike Meyer <mwm@mired.org> http://www.mired.org/consulting.html
Independent WWW/Perforce/FreeBSD/Unix consultant, email for more information.
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-sql@postgresql.org
Cc: mwm@mired.org
Subject: Re: Rule for updating through a view.
In-Reply-To: <15993.51116.466721.722550@guru.mired.org>
* 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