Postgres Pro
Downloads
Home   >   mailing lists

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

From PSequel Support
Subject Escaping issues with queries using the `?` operator
Date
Msg-id CABqkTWT0zERofvfy2VJ+AaMKkdrr2vD=9tpxEz7hD_N5ejoMNg@mail.gmail.com
Whole thread Raw
Responses Re: Escaping issues with queries using the `?` operator
List pgsql-odbc
Tree view
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

pgsql-odbc by date:

Previous
From: "Venkatesan, Sekhar"
Date:
Subject: Re: PostgreSQL: SQLSetPos fails with SetPos update return error.
Next
From: "Venkatesan, Sekhar"
Date:
Subject: Re: PostgreSQL: SQLSetPos fails with SetPos update return error.