Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
PostgreSQL aggregate JSON recordset keys by row
--PostgreSQL 9.6 --'\\' is a delimiter select version() as postgresql_version; create table jsontable ( id integer, data json ); INSERT INTO jsontable VALUES (1, '[{"a": 1, "b": 2}, {"a": 3, "b":2}]'); INSERT INTO jsontable VALUES (2, '[{"a": 5, "b": 8}, {"a": 9, "b":0}]'); select * from jsontable;
run
|
edit
|
history
|
help
0
w3c sql data
Q4
podd version
1225. Report Contiguous Dates
Recursive inefficiency
extract_pairs
2
Ankit
sample
Black Wall