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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: hstore each() function - returned order??
Date: 2021-03-12 08:19:08
Message-ID: CAKFQuwZqgS-RMhEXdBWj1PjpTVmGfeVMw_06EXnyAUe1WOgLVw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brent Wood 2021-03-12 10:17:49 Re: hstore each() function - returned order??
Previous Message Brent Wood 2021-03-12 03:46:58 hstore each() function - returned order??