Changes between Initial Version and Version 1 of Ticket #35539, comment 3


Ignore:
Timestamp:
Jun 21, 2024, 8:17:04 AM (3 months ago)
Author:
Simon Charette

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #35539, comment 3

    initial v1  
    2828> Notice that the 2-argument version of `to_tsvector` is used. '''Only text search functions that specify a configuration name can be used in expression indexes''' (Section 11.7). This is because the index contents must be unaffected by `default_text_search_config`. If they were affected, the index contents might be inconsistent because different entries could contain `tsvectors` that were created with different text search configurations, and there would be no way to guess which was which. It would be impossible to dump and restore such an index correctly.
    2929
    30 So for the same reason `Concat` cannot be used in indices because it relies on alterable global configuration `SearchVector` cannot be used in indices without specifying a `config` because they do not use the same ''stop-words''
     30So for the same reason `Concat` cannot be used in indices because it relies on alterable global configuration `SearchVector` cannot be used in indices without specifying a `config` because they do not use the same stopwords and stoplists
    3131
    3232{{{#!sql
Back to Top