Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

PostgreSQL aggregate JSON recordset keys by row

Language: Layout:
absolute service time: 0,41 sec 
fork mode |  history  | discussion
   postgresql_version
1 PostgreSQL 9.6.2, compiled by Visual C++ build 1800, 64-bit
   id data
1 1 [{"a": 1, "b": 2}, {"a": 3, "b":2}]
2 2 [{"a": 5, "b": 8}, {"a": 9, "b":0}]