pl/pgsql FOUND variables and RULES

From: Sven W <sven(at)dmv(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pl/pgsql FOUND variables and RULES
Date: 2009-06-01 22:29:31
Message-ID: 4A24564B.90808@dmv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a volatile function (trigger) that gathers NEW.*, parses them, then inserts a
subset of values into a different table.

The table is set up as an inherited table where the parent table has a RULE :

CREATE RULE myrule AS ON INSERT TO mytable WHERE ( myfield >= 100 and myfield < 200)
DO INSTEAD
INSERT INTO mytable_100 (field1,field2,field3,myfield) VALUES
(NEW.field1,NEW.field2, NEW.field3, NEW.myfield);

Now when the trigger fires the insert does happen and ends up in mytable_100 but the
FOUND variable is not set (since technically 0 rows got inserted into mytable). Is
there a proper way to set up rules such that the FOUND variable is set within
pl/pgsql upon a successful insert (via the rule) or how can I check for a successful
insert?

Sven

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-06-01 22:48:58 Re: pl/pgsql FOUND variables and RULES
Previous Message Scott Bailey 2009-06-01 22:05:02 Re: xml to table (as oppose to table to xml)