Re: jsonb problematic operators

From: Geoff Winkless <gwinkless(at)gmail(dot)com>
To: Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: jsonb problematic operators
Date: 2016-12-16 09:58:12
Message-ID: CAEzk6fe0B8M5dHf-zz0pnM29=Q7abcrT_kEZxGgH1mHvX-zQyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 16 December 2016 at 09:35, Craig Ringer <craig(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mithun Cy 2016-12-16 10:16:17 Re: Cache Hash Index meta page.
Previous Message Craig Ringer 2016-12-16 09:35:14 Re: jsonb problematic operators