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