VCS: add support for phrase matching in PostgreSQL fulltext search
------------------------------------------------------------------
Key: NXP-6720
URL: https://jira.nuxeo.com/browse/NXP-6720
Project: Nuxeo Enterprise Platform
Issue Type: New Feature
Components: Core, Search / Query
Reporter: Florent Guillaume
Assignee: Florent Guillaume
Priority: Major
Fix For: 5.4.3
For PostgreSQL, where this feature is not supported natively, we will match the
phrase "foo bar" using:
to_tsquery('foo & bar') @@ to_tsvector(fulltext) AND fulltext LIKE '% foo bar
%'
This means that the fulltext column will have to be in clear text,
pre-canonicalized (lowercase, no diacritics), and with an initial and trailing
space.
Note that a more complex match like
abc "foo bar" -"gee man"
will have to be turned into something like:
to_tsquery('abc & foo & bar') @@ to_tsvector(fulltext)
AND (fulltext LIKE '% foo bar %' AND NOT fulltext LIKE '% gee man %')
i.e., the initial fulltext match has to match a superset of the complete query,
so it cannot easily contain excluded phrases.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
ECM-tickets@lists.nuxeo.com
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
