Re: SQL Rule

["Bert" <clemens(dot)bertschler(at)gmail(dot)com>]

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