X-Original-To: pgsql-sql@postgresql.org
Received: from mired.org (ip68-97-54-220.ok.ok.cox.net [68.97.54.220])
	by postgresql.org (Postfix) with SMTP id A4889475C3D
	for <pgsql-sql@postgresql.org>; Thu, 20 Mar 2003 08:52:41 -0500 (EST)
Received: (qmail 2453 invoked from network); 20 Mar 2003 13:52:45 -0000
Received: from localhost.mired.org (HELO guru.mired.org) (127.0.0.1)
	by localhost.mired.org with SMTP; 20 Mar 2003 13:52:45 -0000
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <15993.51116.466721.722550@guru.mired.org>
Date: Thu, 20 Mar 2003 07:52:44 -0600
To: pgsql-sql@postgresql.org
Subject: Rule for updating through a view.
X-Mailer: VM 7.07 under 21.1 (patch 14) "Cuyahoga Valley" XEmacs Lucid
X-face: "5Mnwy%?j>IIV\)A=):rjWL~NB2aH[}Yq8Z=u~vJ`"(,&SiLvbbz2W`;
	h9L,Yg`+vb1>RG% 	*h+%X^n0EZd>TM8_IB;a8F?(Fb"lw'IgCoyM.[Lg#r\
From: Mike Meyer <mwm@mired.org>
X-Delivery-Agent: TMDA/0.71 (Hoop, Jr.)
X-Archive-Number: 200303/508
X-Sequence-Number: 12547

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.