PostgreSQL jsonb, `?` and JDBC

by

As a workaround to avoid the ? operator, you could create a new operator doing exactly the same.

This is the code of the original operator:

CREATE OPERATOR ?(
  PROCEDURE = jsonb_exists,
  LEFTARG = jsonb,
  RIGHTARG = text,
  RESTRICT = contsel,
  JOIN = contjoinsel);

SELECT '{"a":1, "b":2}'::jsonb ? 'b'; -- true

Use a different name, without any conflicts, like #-# and create a new one:

CREATE OPERATOR #-#(
  PROCEDURE = jsonb_exists,
  LEFTARG = jsonb,
  RIGHTARG = text,
  RESTRICT = contsel,
  JOIN = contjoinsel);

SELECT '{"a":1, "b":2}'::jsonb #-# 'b'; -- true

Use this new operator in your code and it should work.

Check pgAdmin -> pg_catalog -> Operators for all the operators that use a ? in the name.

More Related Contents:

  1. The infamous java.sql.SQLException: No suitable driver found
  2. How to perform update operations on columns of type JSONB in Postgres 9.4
  3. ClassNotFoundException with PostgreSQL and JDBC
  4. Postgresql query array of objects in JSONB field
  5. how to store PostgreSQL jsonb using SpringBoot + JPA?
  6. clojure.java.jdbc lazy query
  7. How to escape question mark (?) character with Spring JpaRepository
  8. What is PostgreSQL equivalent to autoincrement?
  9. How do I specify a password to ‘psql’ non-interactively?
  10. Use multiple conflict_target in ON CONFLICT clause
  11. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  12. Where does PostgreSQL store the database?
  13. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  14. How to add “on delete cascade” constraints?
  15. Is there a way to disable function overloading in Postgres
  16. Grant all on a specific schema in the db to a group role in PostgreSQL
  17. Migrate database from Postgres to MySQL [closed]
  18. How can I start PostgreSQL on Windows?
  19. PostgreSQL – max number of parameters in “IN” clause?
  20. SQLAlchemy, Psycopg2 and Postgresql COPY
  21. Why can I create a table with PRIMARY KEY on a nullable column?
  22. Oracle SQL Developer and PostgreSQL
  23. PostgreSQL array of elements that each are a foreign key
  24. How to reset sequence in postgres and fill id column with new data?
  25. Configure JPA to let PostgreSQL generate the primary key value
  26. ERROR: unterminated quoted string at or near
  27. How can I send some http request from postgresql function or trigger
  28. Alternate output format for psql showing one column per line with column name
  29. Destroying a Postgres DB on Heroku
  30. How to drop PostgreSQL database through command line [closed]

Leave a Comment