JSqlParser icon indicating copy to clipboard operation
JSqlParser copied to clipboard

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

Open pshirshov opened this issue 10 years ago • 1 comments

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);

pshirshov avatar Oct 23 '15 12:10 pshirshov

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.

wumpz avatar Oct 24 '15 21:10 wumpz