maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_alerts_markviewed(date)
Parameters
Name
Type
Mode
markdate
date
IN
Definition
DECLARE c INTEGER; BEGIN SET timezone = 'UTC'; CREATE TEMPORARY TABLE tmp_alert AS SELECT idalert FROM alert WHERE alertdate < markdate AND enabled = true; UPDATE alert a SET enabled = false FROM tmp_alert t WHERE t.idalert = a.idalert; GET DIAGNOSTICS c := ROW_COUNT; RETURN c; END;