Annotation: core.get_base_quantity_by_unit_name

CREATE OR REPLACE FUNCTION core.get_base_quantity_by_unit_name(text, integer)
RETURNS numeric

Information: core.get_base_quantity_by_unit_name

Schema	core
Function Name	get_base_quantity_by_unit_name
Arguments	text, integer
Owner	postgres
Result Type	numeric
Description

Implementation: core.get_base_quantity_by_unit_name

CREATE OR REPLACE FUNCTION core.get_base_quantity_by_unit_name(text, integer)
 RETURNS numeric
 LANGUAGE plpgsql
 STABLE
AS $function$
	DECLARE _unit_id integer;
	DECLARE _root_unit_id integer;
	DECLARE _factor decimal;
BEGIN
    _unit_id := core.get_unit_id_by_unit_name($1);
    _root_unit_id = core.get_root_unit_id(_unit_id);
    _factor = core.convert_unit(_unit_id, _root_unit_id);

    RETURN _factor * $2;
END
$function$