| Info | ||
|---|---|---|
| ||
This page is a work in progress. This info box will be removed once complete. |
This page covers a general section on how to perform some non-trivial functions
...
Postgres has ? operator that is used to search a string exist search whether a string exist as a top-level key within the a JSON valueobject. However ? is used used in Java java JDBC to denote placeholder for a prepared statement, Java java JDBC will then inject the actual value for the placeholder at runtime when executing the statement.
So for one to use postgres ? operator one must use ?? so the clause is not parsed as placeholder for prepared statement. An example is shown below
...