maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_alertsmarkcust(character varying)
Parameters
Name
Type
Mode
_clientcode
character varying
IN
Definition
DECLARE counter integer; BEGIN WITH q AS (SELECT iddevice FROM device d JOIN technicalaccount t ON t.idtechnicalaccount = d.idtechnicalaccount JOIN client c ON c.idclient = t.idclient WHERE clientcode = _clientcode), q1 as (UPDATE alert a SET enabled = false FROM q WHERE q.iddevice = a.iddevice RETURNING *) SELECT count(*) INTO counter FROM q1; RETURN counter; END;