maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_device_fill_zeroes()
Parameters
Name
Type
Mode
Definition
DECLARE BEGIN IF NEW.idmodeldevice = 1 AND length(NEW.serialnumber) = 7 THEN NEW.serialnumber := lpad(NEW.serialnumber,12,'0'); END IF; RETURN NEW; END;