[ 
https://jira.nuxeo.com/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, see NXP-6720.


  was:
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.



> VCS: add support for phrase matching in fulltext search
> -------------------------------------------------------
>
>                 Key: NXP-5450
>                 URL: https://jira.nuxeo.com/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.2
>
>
> This feature will only be available for databases which supports phrase 
> matching.
> For PostgreSQL, see NXP-6720.

--
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

Reply via email to