gis
.gobs
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
trg_after_import_validation()
Parameters
Name
Type
Mode
IN
Definition
DECLARE _output integer; BEGIN IF TG_OP = 'UPDATE' AND NEW.im_status = 'V' AND NEW.im_status != OLD.im_status THEN UPDATE gobs.observation SET ob_validation = now() WHERE TRUE AND fk_id_import = NEW.id ; END IF; RETURN NEW; END;