search

impossibl / pgjdbc-ng

A new JDBC driver for PostgreSQL aimed at supporting the advanced features of JDBC and Postgres
https://impossibl.github.io/pgjdbc-ng
Other
596 stars 108 forks source link

Does it support MATCH_RECOGNIZE? #580

Closed fantasy0v0 closed 1 year ago

fantasy0v0 commented 1 year ago

https://docs.oracle.com/database/121/JJDBC/apxref.htm#CHECHCJH

I often use the following code

select '{"foo": 1}'::jsonb ? 'foo';

This will give an error in PreparedStatement.

kdubb commented 1 year ago

PostgreSQL doesn't support it. This is a driver for PostgreSQL.

fantasy0v0 commented 1 year ago

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

kdubb commented 1 year ago

I'm not sure what you're referencing with that link? You asked about MATCH_RECOGNIZE which is an Oracle operator not supported by PostgreSQL. If you were asking using a ?, then yes you can escape them with ??.

fantasy0v0 commented 1 year ago

I'm not sure what you're referencing with that link? You asked about MATCH_RECOGNIZE which is an Oracle operator not supported by PostgreSQL. If you were asking using a ?, then yes you can escape them with ??.

sorry, I was looking for how to use ? in PreparedStatement before this. when I looked at this link, I found that I asked a stupid question. I'm just documenting how I solved it.