title: How to iterate over an array of json object in postgresql and access its elements
body: <p>I have very little experience with postgresql and was wondering how i can access certain fields from an array of json object so i can dynamically use them;</p>
  <p>here is what the array i am trying to iterate looks like:
  ``</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>[
      {
        "days": [
          {
            "dew": -1.1,
            "icon": "snow",
            "snow": 3.2,
            "temp": 0.5,
            "precip": 3.7,
            "source": "fcst",
            "sunset": "17:36:42",
            "sunrise": "07:31:09",
            "tempmax": 1.2,
            "tempmin": -0.6,
            "uvindex": 0,
            "winddir": 220.3,
            "datetime": "2022-02-25",
            "humidity": 89.1,
            "pressure": 996,
            "stations": null,
            "windgust": 61.2,
            "feelslike": -6.2,
            "moonphase": 0.84,
            "snowdepth": 1.4,
            "windspeed": 39.2,
            "cloudcover": 95.7,
            "conditions": "Snow, Rain, Overcast",
            "precipprob": 95.2,
            "preciptype": [
              "rain",
              "snow"
            ],
            "severerisk": 10,
            "visibility": 6.9,
            "description": "Cloudy skies throughout the day with rain or snow clearing later.",
            "precipcover": null,
            "solarenergy": 1.2,
            "sunsetEpoch": 1645803402,
            "feelslikemax": -5.5,
            "feelslikemin": -6.6,
            "sunriseEpoch": 1645767069,
            "datetimeEpoch": 1645740000,
            "solarradiation": 11.6
          }
        ],
        "address": "Helsinki, Finland",
        "latitude": 60.1712,
        "timezone": "Europe/Helsinki",
        "tzoffset": 2,
        "longitude": 24.9327,
        "queryCost": 1,
        "resolvedAddress": "Helsinki, Etelä-Suomi, Suomi"
      }
    ]</code></pre>
  </div>
  </div>
  </p>
  <p>i am trying to access the following fields: address, timezone, datetime, temperature, humidity, precipitation, wind, conditions.</p>
  <p>And here is how i want to dynamically reference those fields inside my function (wdata is the array):
  <a href="https://i.stack.imgur.com/RhyhG.png" rel="nofollow noreferrer">https://i.stack.imgur.com/RhyhG.png</a></p>