On Thursday, March 11, 2021, Brent Wood <brent.w...@niwa.co.nz> wrote:
> Hi, > > I'm using the following in an SQL : > > select (EACH(value)).key as measurement_key, > (EACH(value)).value as value > from t_reading_hstore; > > Just move the each call to the from clause as a lateral join and treat the result as a two-column table. David J.
