Annotation: core.get_item_code_by_item_id

CREATE OR REPLACE FUNCTION core.get_item_code_by_item_id(integer)
RETURNS text

Information: core.get_item_code_by_item_id

Schema	core
Function Name	get_item_code_by_item_id
Arguments	integer
Owner	postgres
Result Type	text
Description

Implementation: core.get_item_code_by_item_id

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