Re: [GENERAL] pl/pgsql FOUND variables and RULES

2009-06-01 Thread Tom Lane
Sven W writes: > 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

[GENERAL] pl/pgsql FOUND variables and RULES

2009-06-01 Thread Sven W
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 IN