On 12 Dec. 2016 22:22, "Merlin Moncure" <mmonc...@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.

Reply via email to