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

From Craig Ringer
Subject Re: [HACKERS] jsonb problematic operators
Date
Msg-id CAMsr+YG6j0gLCxpa+AmWMN8_SUO=jK4VtP5MLhE-MACxW0SZ+A@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] jsonb problematic operators  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On 12 Dec. 2016 22:22, "Merlin Moncure" <mmoncure@gmail.com> wrote:
 If we really wanted to fix this, maybe the right way
to think about the problem is a highly reduced character set and a
pre-processor or an extension.

I'm pretty OK with expecting client drivers not to be stupid and offer escape syntax for their placeholders. I was kind of astonished the jdbc spec doesn't given how hard it works to be compatible. I'd assumed the ?? was jdbc standard not a postgres extension until I looked into it.

Certainly PDO needs a patch for its postgres driver if not (preferably) to support escaping at a higher level.

Users can work around it by defining their own operator aliases + opclasses or using function forms.

Doesn't seem worth too much drama though it sucks for usability.

pgsql-hackers by date:

Previous
From: Ian Jackson
Date:
Subject: Re: [HACKERS] [OSSTEST PATCH 0/1] PostgreSQL db: Retry on constraint violation
Next
From: Craig Ringer
Date:
Subject: Re: [HACKERS] background sessions