Does the JDBC spec prevent ‘?’ from being used as an operator (outside of quotes)?

by

If you have the latest postgresql driver you can use:

??

Changing the original query:

SELECT * FROM tbl WHERE tbl.data ?? 'abc'

Details are in this pull request – https://github.com/pgjdbc/pgjdbc/pull/227
This change was made long after the original question, but it’s worth noting that there’s an easy answer now.

More Related Contents:

  1. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  2. Error: Column does not exist
  3. Select first row in each GROUP BY group?
  4. How to concatenate strings of a string field in a PostgreSQL ‘group by’ query?
  5. How to use RETURNING with ON CONFLICT in PostgreSQL?
  6. PostgreSQL DISTINCT ON with different ORDER BY
  7. IN vs ANY operator in PostgreSQL
  8. Escaping keyword-like column names in Postgres
  9. Delete duplicate rows (don’t delete all duplicate)
  10. GROUP BY + CASE statement
  11. Split column into multiple rows in Postgres
  12. subquery in FROM must have an alias
  13. SQL Between clause with strings columns
  14. Insert an image in postgresql database
  15. Perform this hours of operation query in PostgreSQL
  16. Getting date list in a range in PostgreSQL
  17. Postgres Dynamic Query Function
  18. How do I delete a fixed number of rows with sorting in PostgreSQL?
  19. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  20. How to find a table having a specific column in postgresql
  21. How to read the contents of an .sql file into an R script to run a query?
  22. PostgreSQL JOIN with array type with array elements order, how to implement?
  23. INSERT COMMAND :: ERROR: column “value” does not exist
  24. Return multiple columns and rows from a function PostgreSQL instead of record
  25. Check whether string is a date Postgresql
  26. SQL LIKE condition to check for integer?
  27. Counting the number of occurrences of a substring within a string in PostgreSQL
  28. PostgreSQL: Full Text Search – How to search partial words?
  29. Temporal database design, with a twist (live vs draft rows)
  30. How to bulk insert only new rows in PostreSQL

Leave a Comment