Annotation: policy.is_elevated_user

Information: policy.is_elevated_user

Implementation: policy.is_elevated_user

CREATE OR REPLACE FUNCTION policy.is_elevated_user(_user_id integer)
 RETURNS boolean
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF EXISTS
    (
        SELECT 0 FROM office.users
        WHERE user_id = $1
        AND elevated
    ) THEN
        RETURN true;
    END IF;

    RETURN false;
END;
$function$