Postgres JSON/B array slice

json_sub_array.sql

/*
Taken & expanded from https://stackoverflow.com/a/40377186/4453925
*/
drop function if exists json_sub_array(json, int, int);
create or replace function json_sub_array(json_array json, from_pos int, to_pos int)
returns json language sql as $$
    select json_agg(value)
    from json_array_elements(json_array) with ordinality
    where ordinality-1 between from_pos and to_pos
$$;

drop function if exists json_sub_array(json, int);
create or replace function json_sub_array(json_array json, from_pos int)
returns json language sql as $$
    select json_sub_array(json_array, from_pos, json_array_length(json_array));
$$;

drop function if exists jsonb_sub_array(jsonb, int, int);
create or replace function jsonb_sub_array(jsonb_array jsonb, from_pos int, to_pos int)
returns jsonb language sql as $$
    select jsonb_agg(value)
    from jsonb_array_elements(jsonb_array) with ordinality
    where ordinality-1 between from_pos and to_pos;
$$;

drop function if exists jsonb_sub_array(jsonb, int);
create or replace function jsonb_sub_array(jsonb_array jsonb, from_pos int)
returns jsonb language sql as $$
    select jsonb_sub_array(jsonb_array, from_pos, jsonb_array_length(jsonb_array));
$$;