Annotation: core.is_valid_unit_id

Information: core.is_valid_unit_id

Implementation: core.is_valid_unit_id

CREATE OR REPLACE FUNCTION core.is_valid_unit_id(_unit_id integer, _item_id integer)
 RETURNS boolean
 LANGUAGE plpgsql
AS $function$
BEGIN
        IF EXISTS
        (
                SELECT 1
                FROM core.items
                WHERE item_id = $2
                AND core.get_root_unit_id($1) = core.get_root_unit_id(unit_id)
        ) THEN
                RETURN true;
        END IF;

        RETURN false;
END
$function$