search

seancorfield / next-jdbc

A modern low-level Clojure wrapper for JDBC-based access to databases.
https://cljdoc.org/d/com.github.seancorfield/next.jdbc/
Eclipse Public License 1.0
768 stars 90 forks source link

how to escape ? as jsonb operator for postgresql query? #168

Closed lanyusan closed 3 years ago

lanyusan commented 3 years ago

? is a legitmate operator for jsonb in postgresql.

postgresql jsonb

How to escape it in sql string for example ? select * from blog where commenters ? 'julia'?

seancorfield commented 3 years ago

See https://jdbc.postgresql.org/documentation/head/statement.html

lanyusan commented 3 years ago

Thanks