Annotation: core.is_valid_item_id

CREATE OR REPLACE FUNCTION core.is_valid_item_id(integer)
RETURNS boolean

Information: core.is_valid_item_id

Schema	core
Function Name	is_valid_item_id
Arguments	integer
Owner	postgres
Result Type	boolean
Description

Implementation: core.is_valid_item_id

CREATE OR REPLACE FUNCTION core.is_valid_item_id(integer)
 RETURNS boolean
 LANGUAGE plpgsql
AS $function$
BEGIN
        IF EXISTS(SELECT 1 FROM core.items WHERE item_id=$1) THEN
                RETURN true;
        END IF;

        RETURN false;
END
$function$