Обсуждение: Escaping issues with queries using the `?` operator

Поиск
Список
Период
Сортировка

Escaping issues with queries using the `?` operator

От
PSequel Support
Дата:
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

Re: Escaping issues with queries using the `?` operator

От
"Inoue, Hiroshi"
Дата:
Hi,

On 2016/06/06 15:26, PSequel Support wrote:
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