[
https://jira.nuxeo.com/browse/NXP-6720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume resolved NXP-6720.
------------------------------------
Resolution: Fixed
Implemented.
http://hg.nuxeo.org/nuxeo/nuxeo-core/rev/cff507015fad
> 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 SQL Storage, Search / Query
> Reporter: Florent Guillaume
> Assignee: Florent Guillaume
> Priority: Major
> Fix For: 5.5
>
>
> For PostgreSQL, where this feature is not supported natively, we will match
> the phrase {{"foo bar"}} using:
> {noformat}
> to_tsquery('foo & bar') @@ to_tsvector(fulltext)
> AND fulltext LIKE '% foo bar %'
> {noformat}
> 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
> {noformat}
> abc "foo bar" -"gee man"
> {noformat}
> will have to be turned into something like:
> {noformat}
> to_tsquery('abc & foo & bar') @@ to_tsvector(fulltext)
> AND (fulltext LIKE '% foo bar %' AND NOT fulltext LIKE '% gee man %')
> {noformat}
> 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
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
