Hi Kenneth
Thats exactly what i want, because we are running more selects than
inserts, and therefore a view is not the best way to go.
But I still have a problem, I was doing like you told me.
I have still the same table (without the rules definition)
So I created a trigger function:
CREATE FUNCTION trigger_test()
RETURNS TRIGGER
AS 'BEGIN
new.c = (new.a + new.b);
RETURN new;
END;'
LANGUAGE 'plpgsql';
and then the Trigger:
CREATE TRIGGER trigger_sum
AFTER INSERT OR UPDATE
ON test
FOR EACH ROW
EXECUTE PROCEDURE trigger_test();
The inserting and updating is doing well, but its not summing up the a
and b and save it to the c column. So far maybe you can help me second
time.
Thanks,
Bert
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
