597
597
-- The array on the right side is contained within the one on the left:
598
598
SELECT '[1, 2, 3]'::jsonb @> '[1, 3]'::jsonb;
601
SELECT '[1, 2, 3]'::jsonb @> '[3, 1]'::jsonb;
604
SELECT '[1, 2, 3]'::jsonb @> '[1, 2, 2]'::jsonb;
600
606
-- The object with a single pair on the right side is contained
601
607
-- within the object on the left side:
602
608
SELECT '{"product": "PostgreSQL", "version": 9.4, "jsonb":true}'::jsonb @> '{"version":9.4}'::jsonb;