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
Atuação
PostgresInsertIfNotExists
hw
Black Wall
Professional Networking Social Media Website SQL Analysis
Query workaround in order to avoid IN Operator in WHERE Clause
Assignment 1(SET A)
Finale8E9237394
PostreSQL: Today's Date/Time
1