Annotation: core.get_unit_id_by_unit_name

Information: core.get_unit_id_by_unit_name

Implementation: core.get_unit_id_by_unit_name

CREATE OR REPLACE FUNCTION core.get_unit_id_by_unit_name(text)
 RETURNS integer
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
    (
        SELECT
            core.units.unit_id
        FROM
            core.units
        WHERE
            core.units.unit_name=$1
    );
END
$function$