func.sql

create or replace function get_partitions(spec text, conditions text)
	returns table (id bigint, partition jsonb)
as
$body$
	select j.ord, j.value
	from subscriptions_fulfillmentplan plan, jsonb_array_elements(plan.new_segments) segment, jsonb_array_elements(segment->'partitions') with ordinality as j(value,ord) 
	where plan.spec = spec
	and segment->'rule'->>'conditions' = conditions
$body$
language sql;