Re: SQL/JSON path issues/questions

From: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
To: Thom Brown <thom(at)linux(dot)com>
Cc: Liudmila Mantrova <l(dot)mantrova(at)postgrespro(dot)ru>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SQL/JSON path issues/questions
Date: 2019-07-11 15:23:20
Message-ID: CAPpHfdsSW2ULL3cYowLWwMV=FGBFQ2H5NYRZ0dyN9YJ5GAsqdg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jul 11, 2019 at 5:10 PM Thom Brown <thom(at)linux(dot)com> wrote:
> On Wed, 10 Jul 2019 at 05:58, Alexander Korotkov
> <a(dot)korotkov(at)postgrespro(dot)ru> wrote:
> >
> > On Mon, Jul 8, 2019 at 12:30 AM Alexander Korotkov
> > <a(dot)korotkov(at)postgrespro(dot)ru> wrote:
> > > On Thu, Jul 4, 2019 at 4:38 PM Liudmila Mantrova
> > > <l(dot)mantrova(at)postgrespro(dot)ru> wrote:
> > > > Thank you!
> > > >
> > > > I think we can make this sentence even shorter, the fix is attached:
> > > >
> > > > "To refer to a JSON element stored at a lower nesting level, add one or
> > > > more accessor operators after <literal>@</literal>."
> > >
> > > Thanks, looks good to me. Attached revision of patch contains commit
> > > message. I'm going to commit this on no objections.
> >
> > So, pushed!
>
> I've just noticed the >= operator shows up as just > in the "jsonpath
> Filter Expression Elements" table, and the <= example only shows <.

Thank you for catching this! Fix just pushed.

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rafia Sabih 2019-07-11 15:34:42 Fwd: [HACKERS] [WIP] Effective storage of duplicates in B-tree index.
Previous Message Bruce Momjian 2019-07-11 15:10:14 Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)