On Thursday, March 11, 2021, Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)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.