JSqlParser
JSqlParser copied to clipboard
Postgresql's FTS queries and function-based indexes are not supported
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);
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.