On Wed, 2004-11-17 at 12:49, Robert Fitzpatrick wrote: > On Wed, 2004-11-17 at 11:49, Michael Fuhr wrote: > > 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 > > > > Thanks, that explains a lot, but still not able to get my rule to work, > this is what I have now: > Forget that last post, it is working even though the UPDATE 0 is returned. The record did update :) Please someone let me know if you see any issues with that? Like I said, my first rule let alone with a WHERE condition. -- Robert ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
