Hi, i need a help i have a trigger that fires on insert and cols function X,
in function X a need to update 3 columns of a table like
col1 = (select a from table where id = NEW.ID),
col2 = (select b from table where id = NEW.ID),
col3 = (select c from table where id = NEW.ID)
i wondering is there some posibility to update all this cols with 1 select statment so that the select a,b,c will run only 1 time instade of 3 times.
somthing like select a,b,c and put those values in variable and update cols with those variables.??
thanks