gis
.gobs
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
manage_object_timestamps()
Parameters
Name
Type
Mode
IN
Definition
DECLARE nowtm timestamp; BEGIN nowtm = now(); IF TG_OP = 'INSERT' THEN NEW.created_at = nowtm; NEW.updated_at = nowtm; END IF; IF TG_OP = 'UPDATE' THEN NEW.updated_at = nowtm; END IF; RETURN NEW; END;