chy-causer

create or replace function is_AoA(_input jsonb) returns boolean as $$
  select _input = '[]' or 'array' = all(array_agg(jsonb_typeof(foo))) from (select jsonb_array_elements(_input) foo) x;
$$ language sql immutable;

create table mytest (
  id bigserial primary key,
  myAoA jsonb check (is_AoA(myAoA))
);