Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
code1
Ultima Clase
arjun
Select rows only with values separated by a given interval from other ...
tic tac toe
pokemo
Inner Join
SQL social network practice by Han Wang 20200720 - 2
statistics
Studco