Re: Escaping issues with queries using the `?` operator - Mailing list pgsql-odbc

Hi,

Given a query like this:

SELECT t.val 
FROM (VALUES ('{"a": 1}'::jsonb), ('{"b": 2}'::jsonb)) t (val) 
WHERE t.val ? 'b';

I get this error:

> the # of binded parameters < the # of parameter markers

Hmm, ? as an operator. It conflicts with parameter place holder.
I can't think of the way to fix this issue at once.

regards,
Hiroshi Inoue