Changes between Initial Version and Version 1 of Ticket #35539, comment 3
- Timestamp:
- Jun 21, 2024, 8:17:04 AM (7 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #35539, comment 3
initial v1 28 28 > 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. 29 29 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''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 stopwords and stoplists 31 31 32 32 {{{#!sql