Rule for updating through a view. - Mailing list pgsql-sql

From Mike Meyer
Subject Rule for updating through a view.
Date
Msg-id 15993.51116.466721.722550@guru.mired.org
Whole thread Raw
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: Sethi Tarun-ETS017
Date:
Subject: newline character in SQL
Next
From: "betty"
Date:
Subject: query 2 database