Annotation: core.is_stock_item

Information: core.is_stock_item

Implementation: core.is_stock_item

CREATE OR REPLACE FUNCTION core.is_stock_item(item_code character varying)
 RETURNS boolean
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF EXISTS
    (
        SELECT 1 FROM core.items WHERE core.items.item_code=$1 AND maintain_stock=true
    ) THEN
        RETURN true;
    END IF;

    RETURN false;
END
$function$