CREATE OR REPLACE FUNCTION pagecamel.nameserver_isforcenx(search_domain_name text)
 RETURNS boolean
 LANGUAGE plpgsql
AS $function$ 
DECLARE
    tempvar boolean := false;
BEGIN

    -- Check whitelist (non-regex)
    SELECT INTO tempvar EXISTS(SELECT 1 FROM pagecamel.nameserver_forcenxdomain_whitelist
                  WHERE is_regex = false AND search_domain_name = domain_match);

    IF tempvar = true THEN
        -- whitelisted
        RETURN FALSE;
    END IF; 

    -- Check whitelist (regex)
    SELECT INTO tempvar EXISTS(SELECT 1 FROM pagecamel.nameserver_forcenxdomain_whitelist
                  WHERE is_regex = true AND search_domain_name ~* domain_match);

    IF tempvar = true THEN
        -- whitelisted 
        RETURN FALSE;
    END IF;

    -- Check blacklist (non-regex)
    SELECT INTO tempvar EXISTS(SELECT 1 FROM pagecamel.nameserver_forcenxdomain
                  WHERE is_regex = false AND search_domain_name = domain_match);

    IF tempvar = true THEN
        -- blacklisted
        RETURN TRUE;
    END IF;

    -- Check blacklist (regex)
    SELECT INTO tempvar EXISTS(SELECT 1 FROM pagecamel.nameserver_forcenxdomain
                  WHERE is_regex = true AND search_domain_name ~* domain_match);

    IF tempvar = true THEN
        -- blacklisted
        RETURN TRUE;
    END IF;

        -- Neither, so NOT blacklisted
    RETURN false;
END;
$function$;