Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
test jsonb_set of PostgreSQL
drop table if exists account; create table account(sku text, properties jsonb); insert into account values ('1', '{flags:{"name": "john","type": "food"}, { "name": "doe", "type": "food" } ]') update account set properties = jsonb_set(properties, '', (properties->'') - 'is_new') select * from account;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
prueb final
Tic tac toe
Food Delivery Website SQL Analysis
PostreSQL: CASE
Cross Tab With Totals
SQL - Unpivot Table
select from json[]
FINALE fdjfnkds
hell
Query workaround in order to avoid IN Operator in WHERE Clause
stackse - search stackoverflow differently
Please log in to post a comment.