| 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: | Whole Thread | Raw Message | 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
| 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) |