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

From: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
To: PSequel Support <support(at)psequel(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Escaping issues with queries using the `?` operator
Date: 2016-06-14 03:51:48
Message-ID: 575F7F54.8060407@dream.email.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Venkatesan, Sekhar 2016-06-14 08:33:22 Re: PostgreSQL: SQLSetPos fails with SetPos update return error.
Previous Message Inoue, Hiroshi 2016-06-14 03:47:24 Re: psqlodbc 09.05.0210 commit "Don't do premature execution." Numeric Filter issue?