I have a column called users with this JSON. { "[email protected]":[1.0,5.95], "[email protected]":[2.0,30.733], "[email protected]":[1.0,4.433], "[email protected]":[2.0,16.25] } I want to unwrap it in this way splitUsers firstValue secondValue [email protected] 1.0 5.95 [email protected] 2.0 30.733 [email protected] 1.2 4.433 [email protected] 2.0 16.25 I managed…
I want the syntax to query in postgresql for the data in Json format of the following form into tabular format. data(JSON): 1. { "attr1":"v1", "attr2":[{"subattr":"a1","subattr2":"aa1"},{"subattr":"a2","subattr2":"aa2"}],"attr3":"vv1"} 2. { "attr1":"v2", "attr2":[{"subattr":"b1","subattr2":"bb1"},{"subattr":"b2","subattr2":"bb2"},{"subattr":"b3","subattr2":"bb3"}],"attr3":"vv2"} I am stuck with querying the elements in the "attr2".…
The nested array, stats, consists of objects containing key-value pairs. Each key-value pair is an object with two elements: the first element is the property key and the second element is the property value. The goal is for statName and…
I have two string formatted columns in my table. One of the columns has json objects in it. The keys in the JSON objects are not fixed - so the problem is I cant use standard json extract functions. Here…
Simplifying a bit. I have the following data structure: | id | name | traversal_ids[] | | -------- | -------------- |-----------------| | 1 | container1 | {1} | | 2 | container2 | {2} | | 3 | subcontainer1 |…
I am currently studying SQL and I am still a newbie. I have this task where I need to split some rows with various entries like dates and user IDs. I really need help +-------+------------------------------+---------------------------+ | TYPE | DATES |…
Using PostgreSQL 9.6, I'm trying to insert rows into a table map, generated from another table tbl. tbl name in1 in2 a 1 b 2 {3} c 4 {5,6} d 7 {8,9,10} Should result in this: map name out1 out2…