Re: [HACKERS] jsonb problematic operators - Mailing list pgsql-hackers

From Geoff Winkless
Subject Re: [HACKERS] jsonb problematic operators
Date
Msg-id CAEzk6fe0B8M5dHf-zz0pnM29=Q7abcrT_kEZxGgH1mHvX-zQyg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] jsonb problematic operators  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: [HACKERS] jsonb problematic operators  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 16 December 2016 at 09:35, Craig Ringer <craig@2ndquadrant.com> wrote:
> so it would be consistent with that to use ?? as a literal ? in the
> output query.
>
> This is also what PgJDBC does, per
> https://jdbc.postgresql.org/documentation/head/statement.html . So
> it's consistent .

"Me too".

To look at this from the other angle, is there a reason why the jsonb
indexes don't work with the jsonb_ functions but only with the
operators? Is this something that could be changed easily? It seems
like that would workaround this issue without requiring effort or
agreement from the PHP side.

Geoff



pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: [HACKERS] jsonb problematic operators
Next
From: Mithun Cy
Date:
Subject: Re: [HACKERS] Cache Hash Index meta page.