koski
.oph
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
update_oauth2_jako_aikaleima_columns()
Parameters
Name
Type
Mode
Definition
BEGIN IF row(NEW.*) IS DISTINCT FROM row(OLD.*) THEN NEW.muokattu = current_timestamp; NEW.luotu = OLD.luotu; -- estä luontiaikaleiman muokkaus vahingossa RETURN NEW; ELSE RETURN OLD; END IF; END;