Categories
Database Development

CASE WITH NEW. AND OLD [duplicate]

New problem. from : this task NEED to do 4 state CASE with using OLD. and NEW. value using funcion as trigger There is problem with update only with state WHEN OLD=NEW This is main part of code WHEN ‘UPDATE’ THEN CASE WHEN OLD.nr_w <> NEW.nr_w AND NEW.nr_w <> ‘0’ THEN UPDATE TABLE SET "status" […]