[
https://jira.nuxeo.org/browse/NXP-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=81581#action_81581
]
Florent Guillaume commented on NXP-5450:
----------------------------------------
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.
> Add support for phrase matching in fulltext search
> --------------------------------------------------
>
> Key: NXP-5450
> URL: https://jira.nuxeo.org/browse/NXP-5450
> Project: Nuxeo Enterprise Platform
> Issue Type: Improvement
> Components: Core SQL Storage
> Reporter: Thierry Martins
> Assignee: Florent Guillaume
> Priority: Major
> Fix For: 5.4
>
>
> This feature will only be available for databases which supports phrase
> matching.
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
