search

JSQLParser / JSqlParser

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern
https://github.com/JSQLParser/JSqlParser/wiki
Apache License 2.0
5.43k stars 1.35k forks source link

Postgresql's FTS queries and function-based indexes are not supported #187

Open pshirshov opened 9 years ago

pshirshov commented 9 years ago

The following queries fails to parse:

SELECT to_tsvector('fat cats ate fat rats') @@ to_tsquery('fat & rat');

select * from mytable where (namets @@@ plainto_tsquery('english', 'word')) OR (name % 'another')
  ORDER BY similarity(name, 'blah') DESC

CREATE INDEX name ON table USING gist(column);
wumpz commented 9 years ago

Indeed fts queries are not implemented within JSqlParser. As I never needed to use this ability from Postrgresql I am not familiar with it and what time to provide a first start for it. Pull requests are as always wellcome. It is a bit busy out here, so don't expect a quick implementation.