On Wed, Nov 17, 2004 at 11:20:41AM -0500, Robert Fitzpatrick wrote: > I have a view that used union all to merge three tables together. I was > hoping to create a rule, one for each table using the WHERE condition of > the rule to determine which table gets updated. Is this possible?
See the CREATE RULE documentation: http://www.postgresql.org/docs/7.4/static/sql-createrule.html In particular, read the last paragraph of the Description section, the one that begins, "There is a catch if you try to use conditional rules for view updates...." -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
