Re: hstore each() function - returned order??

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thursday, March 11, 2021, Brent Wood <Brent.Wood@xxxxxxxxxx> 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.