Annotation: office.user_trigger

CREATE OR REPLACE FUNCTION office.user_trigger()
RETURNS trigger

Information: office.user_trigger

Schema	office
Function Name	user_trigger
Arguments
Owner	postgres
Result Type	trigger
Description

Implementation: office.user_trigger

CREATE OR REPLACE FUNCTION office.user_trigger()
 RETURNS trigger
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF(office.is_sys(NEW.user_id) AND NEW.password != '') THEN
        RAISE EXCEPTION 'A sys user cannot have a password.';
    END IF; 

    RETURN new;
END
$function$