-- -- bookmark__get_in_closed_p/2 -- create or replace function bookmark__get_in_closed_p( p_new_parent_id integer, p_user_id integer ) returns bool as $$ DECLARE v_return_value bm_in_closed_p.in_closed_p%TYPE; v_count integer; BEGIN SELECT count(*) INTO v_count FROM bm_in_closed_p WHERE bookmark_id = p_new_parent_id AND in_closed_p_id = p_user_id; IF v_count > 0 THEN SELECT closed_p INTO v_return_value FROM bm_in_closed_p WHERE bookmark_id = p_new_parent_id AND in_closed_p_id = p_user_id; ELSE -- This needs to match the default closed_p value from -- bookmark__initialize_in_closed_p (which is TRUE for all -- except the root folder itself). v_return_value := TRUE; END IF; return v_return_value; END; $$ language plpgsql;