Annotation: core.get_item_id_by_item_code

Information: core.get_item_id_by_item_code

Implementation: core.get_item_id_by_item_code

CREATE OR REPLACE FUNCTION core.get_item_id_by_item_code(text)
 RETURNS integer
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
    (
        SELECT
            item_id
        FROM
            core.items
        WHERE 
            core.items.item_code=$1
    );
END
$function$