Differences

This shows you the differences between two versions of the page.

--- scratchpad:brush_up_search [2016/05/13 15:53] – Adding synonym dictionary instructions provided by Martha Driscoll at NOBLE klussier
+++ scratchpad:brush_up_search [2022/02/10 13:34] (current) – external edit 127.0.0.1
@@ Line 3: / Line 3: @@
 =====Apostrophe Searching=====
-**The problem:** Evergreen uses a modified NACO normalization scheme to better handle apostrophe searching for French records. The problem is that this normalization scheme doesn't work as well for English records as pure NACO normalization does. It also sometimes relies on stemming to find the correct search term, which causes problems for sites that disabled stemming
+**The problem:** Evergreen uses a modified NACO normalization scheme to better handle apostrophe searching for French records. The problem is that this normalization scheme doesn't work as well for English records as pure NACO normalization does. It also sometimes relies on stemming to find the correct search term, which causes problems for sites that disable stemming
 **Who should consider this adjustment:** Evergreen sites with a database the mostly contain English-language records and that are okay with search behavior where a search for a French word like 'histoire' will not retrieve records with l'histoire. There may be other multi-lingual implications for making this tweak. Sites with mostly English records that have also disabled stemming should strongly consider this tweak.
@@ Line 14: / Line 14: @@
 UPDATE config.metabib_field_index_norm_map a
 SET norm = 1
-FROM (SELECT norm FROM config.metabib_field_index_norm_map) AS subquery
+FROM (SELECT id,norm FROM config.metabib_field_index_norm_map) AS subquery
 WHERE subquery.norm = 17 and a.id = subquery.id;
 </code>