Escaping issues with queries using the `?` operator

From: PSequel Support <support(at)psequel(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Escaping issues with queries using the `?` operator
Date: 2016-06-06 06:26:23
Message-ID: CABqkTWT0zERofvfy2VJ+AaMKkdrr2vD=9tpxEz7hD_N5ejoMNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Venkatesan, Sekhar 2016-06-06 06:43:40 Re: PostgreSQL: SQLSetPos fails with SetPos update return error.
Previous Message Venkatesan, Sekhar 2016-05-30 04:59:54 Re: PostgreSQL: SQLSetPos fails with SetPos update return error.