Question: Getting the list of Objects and the corresponding value in Postgres (JSON data)

Question

Getting the list of Objects and the corresponding value in Postgres (JSON data)

Answers 1
Added at 2016-12-30 08:12
Tags
Question

I have the following JSON data which has an array of Objects PRODUCTION -> KBM -> (array of Objects)

What I am looking for is to get all the values for the Version under the KBM.

I am able to pick only any one while I am passing the 0th, 1st or 2nd Object reference like

SELECT (result_json-> 'PRODUCTION' -> 'KBM' -> 0 ->> 'Version') as Version_History
        from sha.assessment_info;

Screenshot of the structure along with the json data :

JSON Data

I don not wish to pass the 0, 1 or 2 each time. I want it in some kind of loop to handle the situation and give me all the versions in one column.

Is there any way to achieve that?

BElow is the JSON Data:

"{
    "PRODUCTION": {
        "KBM": [{
            "Version": "8.3.10.112.1L",
            "Last Updated": "06/05/16 11:20:57 PM"
        },
        {
            "Version": "8.3.8.24",
            "Last Updated": "11/06/14  1:50:07 PM"
        },
        {
            "Version": "8.3.0.16.10",
            "Last Updated": "11/04/14  7:11:23 PM"
        }],
        "EHR": [{
            "Version": "5.8.2.74",
            "Last Updated": "06/03/16  2:06:06 AM"
        },

        {
            "Version": "5.2.14",
            "Last Updated": "12/12/05  4:44:45 PM"
        },
        {
            "Version": "5.2.13",
            "Last Updated": "12/12/05  4:44:44 PM"
        },
        {
            "Version": "5.2.12",
            "Last Updated": "12/12/05  4:44:43 PM"
        },
        {
            "Version": "5.2.11",
            "Last Updated": "12/12/05  4:43:59 PM"
        },
        {
            "Version": "5.2.10",
            "Last Updated": "12/12/05  4:43:57 PM"
        },
        {
            "Version": "5.2.9",
            "Last Updated": "12/12/05  4:43:56 PM"
        },
        {
            "Version": "5.2.8",
            "Last Updated": "12/12/05  4:43:42 PM"
        },
        {
            "Version": "5.2.7",
            "Last Updated": "12/12/05  4:43:17 PM"
        },
        {
            "Version": "5.2.6",
            "Last Updated": "12/12/05  4:43:13 PM"
        },
        {
            "Version": "5.2.5",
            "Last Updated": "12/12/05  4:43:07 PM"
        },
        {
            "Version": "5.2.4",
            "Last Updated": "12/12/05  4:10:43 PM"
        },
        {
            "Version": "5.2.3",
            "Last Updated": "12/12/05  4:10:38 PM"
        },
        {
            "Version": "5.2.2",
            "Last Updated": "12/12/05  4:10:33 PM"
        },
        {
            "Version": "5.2.1",
            "Last Updated": "12/12/05  4:10:20 PM"
        },
        {
            "Version": "5.1.7",
            "Last Updated": "12/12/05  4:10:18 PM"
        },
        {
            "Version": "5.1.6",
            "Last Updated": "12/12/05  4:10:16 PM"
        },
        {
            "Version": "5.1.5",
            "Last Updated": "12/12/05  4:10:15 PM"
        },
        {
            "Version": "5.1.4",
            "Last Updated": "12/12/05  4:05:15 PM"
        },
        {
            "Version": "5.1.3",
            "Last Updated": "12/12/05  4:05:13 PM"
        },
        {
            "Version": "5.1.2",
            "Last Updated": "12/12/05  4:05:08 PM"
        },
        {
            "Version": "5.1.1",
            "Last Updated": "12/12/05  4:05:07 PM"
        },
        {
            "Version": "5.0.33",
            "Last Updated": "12/12/05  4:05:03 PM"
        },
        {
            "Version": "5.0.32",
            "Last Updated": "12/12/05  4:05:02 PM"
        },
        {
            "Version": "5.0.31",
            "Last Updated": "09/14/04  6:09:55 PM"
        },
        {
            "Version": "5.0.27",
            "Last Updated": "08/25/04  1:40:37 PM"
        }],
        "EPM": [{
            "Version": "5.8.2",
            "Last Updated": "06/03/16  1:59:56 AM"
        },
        {
            "Version": "5.8.1",
            "Last Updated": "06/03/16  1:58:22 AM"
        },
        {
            "Version": "5.8.0",
            "Last Updated": "11/04/14  4:40:15 PM"
        },
        {
            "Version": "5.7.3",
            "Last Updated": "11/04/14  4:40:01 PM"
        },
        {
            "Version": "5.7.2",
            "Last Updated": "12/28/11  1:05:20 PM"
        },
        {
            "Version": "5.7.1",
            "Last Updated": "12/28/11  1:03:03 PM"
        },
        {
            "Version": "5.6.6",
            "Last Updated": "12/28/11  1:02:41 PM"
        },
        {
            "Version": "5.6.9",
            "Last Updated": "12/28/11  1:02:08 PM"
        },
        {
            "Version": "5.6.8",
            "Last Updated": "09/02/11  3:31:22 PM"
        },
        {
            "Version": "5.6.7",
            "Last Updated": "09/02/11  3:29:40 PM"
        },
        {
            "Version": "5.6.5",
            "Last Updated": "01/03/11  1:45:01 PM"
        },
        {
            "Version": "5.6.4",
            "Last Updated": "03/27/10  5:43:36 AM"
        },
        {
            "Version": "5.6.3",
            "Last Updated": "03/24/10  5:11:44 PM"
        },
        {
            "Version": "5.6.2",
            "Last Updated": "03/23/10  8:52:27 PM"
        },
        {
            "Version": "5.6.1",
            "Last Updated": "03/23/10  8:45:40 PM"
        },
        {
            "Version": "5.5.28",
            "Last Updated": "11/30/09 10:55:47 AM"
        },
        {
            "Version": "5.5.27",
            "Last Updated": "11/30/09 10:52:32 AM"
        },
        {
            "Version": "5.5.26",
            "Last Updated": "11/30/09 10:52:01 AM"
        },
        {
            "Version": "5.5.25",
            "Last Updated": "11/30/09 10:51:49 AM"
        },
        {
            "Version": "5.5.24",
            "Last Updated": "11/30/09 10:51:28 AM"
        },
        {
            "Version": "5.5.23",
            "Last Updated": "11/30/09 10:50:58 AM"
        },
        {
            "Version": "5.5.22",
            "Last Updated": "11/30/09  8:44:55 AM"
        },
        {
            "Version": "5.5.21",
            "Last Updated": "11/30/09  8:35:03 AM"
        },
        {
            "Version": "5.5.20",
            "Last Updated": "11/30/09  8:34:58 AM"
        },
        {
            "Version": "5.5.19",
            "Last Updated": "11/30/09  8:34:54 AM"
        },
        {
            "Version": "5.5.18",
            "Last Updated": "11/30/09  8:34:49 AM"
        },
        {
            "Version": "5.5.17",
            "Last Updated": "11/30/09  8:34:45 AM"
        },
        {
            "Version": "5.5.16",
            "Last Updated": "11/30/09  8:34:42 AM"
        },
        {
            "Version": "5.5.15",
            "Last Updated": "11/30/09  8:33:32 AM"
        },
        {
            "Version": "5.5.14",
            "Last Updated": "11/30/09  8:33:25 AM"
        },
        {
            "Version": "5.5.13",
            "Last Updated": "11/30/09  8:33:22 AM"
        },
        {
            "Version": "5.5.12",
            "Last Updated": "11/30/09  8:33:20 AM"
        },
        {
            "Version": "5.5.11",
            "Last Updated": "11/30/09  8:31:32 AM"
        },
        {
            "Version": "5.5.10",
            "Last Updated": "11/30/09  8:28:26 AM"
        },
        {
            "Version": "5.5.9",
            "Last Updated": "11/30/09  8:28:22 AM"
        },
        {
            "Version": "5.5.8",
            "Last Updated": "11/30/09  8:12:12 AM"
        },
        {
            "Version": "5.5.7",
            "Last Updated": "11/30/09  8:07:02 AM"
        },
        {
            "Version": "5.5.6",
            "Last Updated": "11/30/09  8:06:58 AM"
        },
        {
            "Version": "5.5.5",
            "Last Updated": "11/30/09  7:57:33 AM"
        },
        {
            "Version": "5.5.4",
            "Last Updated": "11/30/09  7:57:30 AM"
        },
        {
            "Version": "5.5.3",
            "Last Updated": "11/30/09  7:57:27 AM"
        },
        {
            "Version": "5.5.2",
            "Last Updated": "11/30/09  7:51:27 AM"
        },
        {
            "Version": "5.5.1",
            "Last Updated": "11/30/09  7:47:54 AM"
        },
        {
            "Version": "5.5.0",
            "Last Updated": "11/30/09  7:47:50 AM"
        },
        {
            "Version": "5.4.29",
            "Last Updated": "11/30/09  7:46:46 AM"
        },
        {
            "Version": "5.4.28",
            "Last Updated": "11/30/09  7:46:15 AM"
        },
        {
            "Version": "5.4.27",
            "Last Updated": "11/25/09  9:52:17 AM"
        },
        {
            "Version": "5.4.26",
            "Last Updated": "11/25/09  9:52:14 AM"
        },
        {
            "Version": "5.4.25",
            "Last Updated": "11/25/09  9:52:10 AM"
        },
        {
            "Version": "5.4.24",
            "Last Updated": "11/25/09  9:52:07 AM"
        },
        {
            "Version": "5.4.23",
            "Last Updated": "11/25/09  9:52:01 AM"
        },
        {
            "Version": "5.4.22",
            "Last Updated": "11/25/09  9:52:00 AM"
        },
        {
            "Version": "5.4.21",
            "Last Updated": "11/25/09  9:49:05 AM"
        },
        {
            "Version": "5.4.20",
            "Last Updated": "11/25/09  9:49:03 AM"
        },
        {
            "Version": "5.4.19",
            "Last Updated": "11/25/09  9:34:12 AM"
        },
        {
            "Version": "5.4.18",
            "Last Updated": "11/25/09  9:34:09 AM"
        },
        {
            "Version": "5.4.17",
            "Last Updated": "11/25/09  9:30:50 AM"
        },
        {
            "Version": "5.4.16",
            "Last Updated": "11/25/09  9:16:44 AM"
        },
        {
            "Version": "5.4.15",
            "Last Updated": "11/25/09  9:16:41 AM"
        },
        {
            "Version": "5.4.14",
            "Last Updated": "11/25/09  9:12:30 AM"
        },
        {
            "Version": "5.4.13",
            "Last Updated": "11/25/09  9:12:25 AM"
        },
        {
            "Version": "5.4.12",
            "Last Updated": "11/25/09  9:12:22 AM"
        },
        {
            "Version": "5.4.11",
            "Last Updated": "11/25/09  9:12:19 AM"
        },
        {
            "Version": "5.4.10",
            "Last Updated": "11/25/09  9:12:17 AM"
        },
        {
            "Version": "5.4.9",
            "Last Updated": "11/25/09  9:12:14 AM"
        },
        {
            "Version": "5.4.8",
            "Last Updated": "11/25/09  9:01:55 AM"
        },
        {
            "Version": "5.4.7",
            "Last Updated": "11/25/09  9:01:52 AM"
        },
        {
            "Version": "5.4.6",
            "Last Updated": "11/25/09  9:01:50 AM"
        },
        {
            "Version": "5.4.5",
            "Last Updated": "11/25/09  9:01:47 AM"
        },
        {
            "Version": "5.4.4",
            "Last Updated": "11/25/09  8:54:54 AM"
        },
        {
            "Version": "5.4.3",
            "Last Updated": "11/25/09  8:54:50 AM"
        },
        {
            "Version": "5.4.2",
            "Last Updated": "11/25/09  8:54:47 AM"
        },
        {
            "Version": "5.4.1",
            "Last Updated": "11/25/09  8:52:32 AM"
        },
        {
            "Version": "5.3.39",
            "Last Updated": "08/21/06  3:26:33 PM"
        },
        {
            "Version": "5.3.38",
            "Last Updated": "06/21/06  4:41:04 PM"
        },
        {
            "Version": "5.3.37",
            "Last Updated": "01/23/06  3:08:06 PM"
        },
        {
            "Version": "5.3.36",
            "Last Updated": "12/12/05  5:19:37 PM"
        },
        {
            "Version": "5.3.35",
            "Last Updated": "12/12/05  5:19:27 PM"
        },
        {
            "Version": "5.3.34",
            "Last Updated": "12/12/05  5:19:20 PM"
        },
        {
            "Version": "5.3.33",
            "Last Updated": "12/12/05  5:19:16 PM"
        },
        {
            "Version": "5.3.32",
            "Last Updated": "12/12/05  5:13:55 PM"
        },
        {
            "Version": "5.3.31",
            "Last Updated": "12/12/05  5:13:54 PM"
        },
        {
            "Version": "5.3.30",
            "Last Updated": "12/12/05  5:13:51 PM"
        },
        {
            "Version": "5.3.29",
            "Last Updated": "12/12/05  5:13:50 PM"
        },
        {
            "Version": "5.3.28",
            "Last Updated": "12/12/05  5:13:48 PM"
        },
        {
            "Version": "5.3.27",
            "Last Updated": "12/12/05  5:13:46 PM"
        },
        {
            "Version": "5.3.26",
            "Last Updated": "12/12/05  5:13:39 PM"
        },
        {
            "Version": "5.3.25",
            "Last Updated": "12/12/05  5:13:37 PM"
        },
        {
            "Version": "5.3.24",
            "Last Updated": "12/12/05  5:13:34 PM"
        },
        {
            "Version": "5.3.23",
            "Last Updated": "12/12/05  5:13:22 PM"
        },
        {
            "Version": "5.3.22",
            "Last Updated": "12/12/05  5:13:21 PM"
        },
        {
            "Version": "5.3.21",
            "Last Updated": "12/12/05  5:13:19 PM"
        },
        {
            "Version": "5.3.20",
            "Last Updated": "12/12/05  5:08:25 PM"
        },
        {
            "Version": "5.3.19",
            "Last Updated": "12/12/05  5:08:20 PM"
        },
        {
            "Version": "5.3.18",
            "Last Updated": "12/12/05  5:08:18 PM"
        },
        {
            "Version": "5.3.17",
            "Last Updated": "12/12/05  5:08:17 PM"
        },
        {
            "Version": "5.3.16",
            "Last Updated": "12/12/05  5:08:16 PM"
        },
        {
            "Version": "5.3.15",
            "Last Updated": "12/12/05  5:08:14 PM"
        },
        {
            "Version": "5.3.14",
            "Last Updated": "12/12/05  5:08:12 PM"
        },
        {
            "Version": "5.3.13",
            "Last Updated": "12/12/05  4:46:09 PM"
        },
        {
            "Version": "5.3.12",
            "Last Updated": "12/12/05  4:46:04 PM"
        },
        {
            "Version": "5.3.11",
            "Last Updated": "12/12/05  4:46:01 PM"
        },
        {
            "Version": "5.3.10",
            "Last Updated": "12/12/05  4:45:57 PM"
        },
        {
            "Version": "5.3.9",
            "Last Updated": "12/12/05  4:45:53 PM"
        },
        {
            "Version": "5.3.8",
            "Last Updated": "12/12/05  4:45:51 PM"
        },
        {
            "Version": "5.3.7",
            "Last Updated": "12/12/05  4:45:45 PM"
        },
        {
            "Version": "5.3.6",
            "Last Updated": "12/12/05  4:45:40 PM"
        },
        {
            "Version": "5.3.5",
            "Last Updated": "12/12/05  4:45:38 PM"
        },
        {
            "Version": "5.3.4",
            "Last Updated": "12/12/05  4:45:34 PM"
        },
        {
            "Version": "5.3.3",
            "Last Updated": "12/12/05  4:45:30 PM"
        },
        {
            "Version": "5.3.2",
            "Last Updated": "12/12/05  4:45:24 PM"
        },
        {
            "Version": "5.3.1",
            "Last Updated": "12/12/05  4:45:05 PM"
        },
        {
            "Version": "5.2.16",
            "Last Updated": "12/12/05  4:44:47 PM"
        },
        {
            "Version": "5.2.15",
            "Last Updated": "12/12/05  4:44:46 PM"
        },
        {
            "Version": "5.2.14",
            "Last Updated": "12/12/05  4:44:45 PM"
        },
        {
            "Version": "5.2.13",
            "Last Updated": "12/12/05  4:44:44 PM"
        },
        {
            "Version": "5.2.12",
            "Last Updated": "12/12/05  4:44:43 PM"
        },
        {
            "Version": "5.2.11",
            "Last Updated": "12/12/05  4:43:59 PM"
        },
        {
            "Version": "5.2.10",
            "Last Updated": "12/12/05  4:43:57 PM"
        },
        {
            "Version": "5.2.9",
            "Last Updated": "12/12/05  4:43:56 PM"
        },
        {
            "Version": "5.2.8",
            "Last Updated": "12/12/05  4:43:42 PM"
        },
        {
            "Version": "5.2.7",
            "Last Updated": "12/12/05  4:43:17 PM"
        },
        {
            "Version": "5.2.6",
            "Last Updated": "12/12/05  4:43:13 PM"
        },
        {
            "Version": "5.2.5",
            "Last Updated": "12/12/05  4:43:07 PM"
        },
        {
            "Version": "5.2.4",
            "Last Updated": "12/12/05  4:10:43 PM"
        },
        {
            "Version": "5.2.3",
            "Last Updated": "12/12/05  4:10:38 PM"
        },
        {
            "Version": "5.2.2",
            "Last Updated": "12/12/05  4:10:33 PM"
        },
        {
            "Version": "5.2.1",
            "Last Updated": "12/12/05  4:10:20 PM"
        },
        {
            "Version": "5.1.7",
            "Last Updated": "12/12/05  4:10:18 PM"
        },
        {
            "Version": "5.1.6",
            "Last Updated": "12/12/05  4:10:16 PM"
        },
        {
            "Version": "5.1.5",
            "Last Updated": "12/12/05  4:10:15 PM"
        },
        {
            "Version": "5.1.4",
            "Last Updated": "12/12/05  4:05:15 PM"
        },
        {
            "Version": "5.1.3",
            "Last Updated": "12/12/05  4:05:13 PM"
        },
        {
            "Version": "5.1.2",
            "Last Updated": "12/12/05  4:05:08 PM"
        },
        {
            "Version": "5.1.1",
            "Last Updated": "12/12/05  4:05:07 PM"
        },
        {
            "Version": "5.0.33",
            "Last Updated": "12/12/05  4:05:03 PM"
        },
        {
            "Version": "5.0.32",
            "Last Updated": "12/12/05  4:05:02 PM"
        },
        {
            "Version": "5.0.31",
            "Last Updated": "09/14/04  6:09:55 PM"
        },
        {
            "Version": "5.0.27",
            "Last Updated": "08/25/04  1:40:37 PM"
        }],
        "DASHBOARD": [{
            "Version": "3.3.1.08",
            "Last Updated": "08/05/16  1:02:00 PM"
        },
        {
            "Version": "3.3.1.08",
            "Last Updated": "08/05/16  1:01:44 PM"
        },
        {
            "Version": "3.3.1.8",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.1.7",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.1.6",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.1.5",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.1.4",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.1.3",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.1.2",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.1.1",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.0.76",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.0.75",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.0.74",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.0.73",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.0.72",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.0.71",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.0.70",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.0.69",
            "Last Updated": "08/05/16  1:00:01 PM"
        },
        {
            "Version": "3.3.0.68",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.67",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.66",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.65",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.64",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.63",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.62",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.61",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.60",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.59",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.58",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.57",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.56",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.55",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.54",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.53",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.52",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.51",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.50",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.49",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.48",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.47",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.46",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.45",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.44",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.43",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.42",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.41",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.40",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.39",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.38",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.37",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.36",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.35",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.34",
            "Last Updated": "08/05/16  1:00:00 PM"
        },
        {
            "Version": "3.3.0.33",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.32",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.31",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.30",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.29",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.28",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.27",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.26",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.25",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.24",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.23",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.22",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.21",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.20",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.19",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.18",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.17",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.16",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.15",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.14",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.13",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.12",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.11",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.10",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.9",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.8",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.7",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.6",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.5",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.4",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.3",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.2",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.3.0.1",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.2.0.20",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.2.0.19",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.2.0.18",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.2.0.17",
            "Last Updated": "08/05/16 12:59:59 PM"
        },
        {
            "Version": "3.2.0.16",
            "Last Updated": "08/05/16 12:59:58 PM"
        },
        {
            "Version": "3.2.0.15",
            "Last Updated": "08/05/16 12:59:58 PM"
        },
        {
            "Version": "3.2.0.14",
            "Last Updated": "08/05/16 12:59:58 PM"
        },
        {
            "Version": "3.2.0.13",
            "Last Updated": "08/05/16 12:59:58 PM"
        },
        {
            "Version": "3.2.0.12",
            "Last Updated": "08/05/16 12:59:58 PM"
        },
        {
            "Version": "3.2.0.11",
            "Last Updated": "08/05/16 12:59:58 PM"
        },
        {
            "Version": "3.2.0.10",
            "Last Updated": "08/05/16 12:59:58 PM"
        },
        {
            "Version": "3.2.0.9",
            "Last Updated": "08/05/16 12:59:58 PM"
        },
        {
            "Version": "3.2.0.8",
            "Last Updated": "08/05/16 12:59:58 PM"
        },
        {
            "Version": "3.2.0.7",
            "Last Updated": "08/05/16 12:59:58 PM"
        },

        {
            "Version": "3.3.1.1",
            "Last Updated": "08/05/16 12:54:54 PM"
        }]
    }

    }
"
Answers
nr: #1 dodano: 2016-12-30 08:12

You need to extract all array elements using jsonb_array_elements and then get the version attribute from the resulting JSONs:

select t ->> 'Version'
from assessment_info, json_array_elements(result_json -> 'PRODUCTION' -> 'KBM') as t(d)
Source Show
◀ Wstecz