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