--
-- 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;