Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
JsonB Query
drop table if exists current; create table current (id serial primary key, model jsonb); insert into current (model) values ('{ "resourceType": "Person", "id": "8a7b72b1-49ec-43e5-bd21-bc62674d9875", "name": [ { "family": [ "NEWMAN" ], "given": [ "JOHN" ] } ] }'); select t.* from current t, jsonb_array_elements(model->'name') names where names->'given' ? 'JOHN';
run
|
edit
|
history
|
help
0
PC02-DB-UTEC
PostreSQL: Full Outer Join
LeetCode 178
1
Movie Rating SQL Analysis Project
test 16721723
xD
test jsonb_set of PostgreSQL
postgresql
Comp