[
https://jira.nuxeo.org/browse/NXP-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=83334#action_83334
]
Florent Guillaume commented on NXP-5450:
----------------------------------------
Implemented for all except PostgreSQL:
http://hg.nuxeo.org/nuxeo/nuxeo-core/rev/5d271764e8c2
> VCS: 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: New Feature
> Components: Core SQL Storage, Search / Query
> 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
