i tried to use trigger

[JJJ777]

hi again ....
base on my previous thread i try this

then when i tried update on table exam this error occured.....

WARNING: plpgsql: ERROR during compile of kira near line 2
ERROR: return type mismatch in function returning tuple at or near "total_marked"

cam someone correct it tq..in advace....


CREATE FUNCTION kira()
RETURNS opaque
AS 'BEGIN
RETURN total_marked = paper_1 + paper_2;
END;'
LANGUAGE 'plpgsql';


CREATE TRIGGER trig_kira
AFTER UPDATE ON exam FOR EACH ROW EXECUTE PROCEDURE kira();

 

[ceco]

try to read this on how to write triggers

http://www.postgresql.org/docs/view.php?version=7.4&idoc=1&file=plpgsql-trigger.html

i think it will get you closer to the idea

and then if you have some questions ask again ;-)