[
https://jira.nuxeo.org/browse/NXP-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-5450:
-----------------------------------
Description:
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.
was:This feature will only be available for databases which supports phrase
matching, what excludes PostgreSQL for a while.
> 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
