aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_department_group_init
Parameters
Name
Type
Mode
Definition
BEGIN NEW.post_type := COALESCE(NEW.post_type, 'P'); IF (new.seq is null) THEN new.seq = (select coalesce(max(seq),0)+1 from department_group); END IF; RETURN NEW; END