hotell=# \h create trigger
Command:     CREATE TRIGGER
Description: Creates a new trigger
Syntax:
CREATE TRIGGER name { BEFORE | AFTER } { event [OR ...] }
    ON table FOR EACH { ROW | STATEMENT }
    EXECUTE PROCEDURE func ( arguments )

create function aeg_into_tootaja() returns opaque as '
begin
    update tootaja set aeg = ((select too.aeg from too where  tootaja.tootaja_id = too.tootajaid)*
    (select raha from amet where amet.amet_id = tootaja.ametid));
return old;
end;' language 'plpgsql'; 

create trigger tdata_into_klient after update on paring for each row execute procedure
data_into_klient();

drop trigger tdata_into_klient;