Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table the_table
(
  id integer primary key generated always as identity,
  data jsonb
);

CREATE TABLE


insert into the_table
  (data) 
values 
  ('["a", "b"]'::jsonb),
  ('["b"]'::jsonb),
  ('["a"]'::jsonb),
  ('["c", "a", "b"]'::jsonb);

INSERT 0 4


select *
from the_table
where data @> '["b","a"]'
  and data <@ '["b","a"]';


id
data


1
["a", "b"]



SELECT 1


select *
from the_table
where data @> '["a","b","c"]'
  and data <@ '["a","b","c"]';


id
data


4
["c", "a", "b"]



SELECT 1