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

From Matteo Beccati
Subject Re: [HACKERS] jsonb problematic operators
Date
Msg-id ce3b6c55-b9e3-6c9c-00a0-e5c57712244a@beccati.com
Whole thread Raw
In response to Re: [HACKERS] jsonb problematic operators  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: [HACKERS] jsonb problematic operators  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-hackers
Hi,

On 12/12/2016 05:09, Craig Ringer wrote:
> Does PDO let you double question marks to escape them, writing ?? or
> \? instead of ? or anything like that?
> 
> If not, I suggest that you (a) submit a postgres patch adding
> alternative operator names for ? and ?|, and (b) submit a PDO patch to
> allow ?? or \? as an escape for ? .

For reference, my plan would be to get "\?" into PDO_pgsql for PHP 7.2.
I've tried to get it into 7.1, but I was a bit too late into the RC
process to safely do that.

Since PDO itself has no escaping yet, I'm open to suggestions wrt to the
actual escape method to use.


Cheers
-- 
Matteo Beccati

Development & Consulting - http://www.beccati.com/



pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: [HACKERS] Declarative partitioning - another take
Next
From: Craig Ringer
Date:
Subject: Re: [HACKERS] jsonb problematic operators