Fwd: function for trigger

[avpro avpro <avprowebeden@xxxxxxxxx>]

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