egdb3_11_7
.config
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
setting_is_user_or_ws()
Parameters
Name
Type
Mode
IN
Definition
BEGIN IF TG_TABLE_NAME = 'usr_setting_type' THEN PERFORM TRUE FROM config.workstation_setting_type cwst WHERE cwst.name = NEW.name; IF NOT FOUND THEN RETURN NULL; END IF; END IF; IF TG_TABLE_NAME = 'workstation_setting_type' THEN PERFORM TRUE FROM config.usr_setting_type cust WHERE cust.name = NEW.name; IF NOT FOUND THEN RETURN NULL; END IF; END IF; RAISE EXCEPTION '% Cannot be used as both a user setting and a workstation setting.', NEW.name; END;