Postgres 9.4

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

select version();

version

PostgreSQL 9.4.26 on x86_64-pc-linux-musl, compiled by gcc (Alpine 11.2.1_git20220219) 11.2.1 20220219, 64-bit

SELECT 1

-- the jsonb type arrived in PostgreSQL 9.4
create table doc (id int, body jsonb);
insert into doc values
  (1,'{"name":"ann","tags":["sql","db"]}'),
  (2,'{"name":"bob","tags":["graph"]}');

CREATE TABLE

INSERT 0 2

select id, body->>'name' as name, body->'tags' as tags
from doc
where body @> '{"tags":["sql"]}';

id
name
tags

1
ann
["sql", "db"]

SELECT 1