maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_genctrlcode()
Parameters
Name
Type
Mode
Definition
DECLARE BEGIN update mayauser u set ctrlcode = (SELECT u.idmayauser::text || c.clientcode::text FROM client c WHERE c.idclient = u.idclient ) where idmayauser = NEW.idmayauser; RETURN NULL; END;