Hi,
I have this function
CREATE OR REPLACE FUNCTION sumlast_func()
RETURNS trigger AS
begin
CASE
WHEN idcar = (select idcar FROM selectedcar) THEN
JOIN selectedcar ON selectedcar.idcar = actuals.idcar)
update actuals
set
comb = comb + (select combor from combor_view
where idlog = (select max(idlog) from combor_view)),
END CASE;
return new;
end
I'm not sure where to create the boolean condition; the options in the
function above or in the trigger below
CREATE TRIGGER update_actuals_tg
AFTER INSERT
ON combor
FOR EACH ROW
EXECUTE PROCEDURE sumlast_func();
and then, is the boolean condition wrong?
thanks for any tips