dev:proposal:search_normalization
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
dev:proposal:search_normalization [2012/11/26 11:11] – created jbond | dev:proposal:search_normalization [2022/02/10 13:34] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 7: | Line 7: | ||
- | NACO normalization standards can be found [http:// | + | NACO normalization standards can be found [[http:// |
The change to normalization is minor. According to NACO standards commas and apostrophes are normalized to white space. This search normalization feature converts commas and apostrophes to nothing rather than white space. The feature can be turned on or off using an internal flag. Using this feature affects the way all data is normalized when using the search_normalize stored procedure. | The change to normalization is minor. According to NACO standards commas and apostrophes are normalized to white space. This search normalization feature converts commas and apostrophes to nothing rather than white space. The feature can be turned on or off using an internal flag. Using this feature affects the way all data is normalized when using the search_normalize stored procedure. | ||
Line 13: | Line 13: | ||
The following stored procedures have been modified: | The following stored procedures have been modified: | ||
| | ||
- | - search_normalize(text) - Modified wrapper function to check if flag was turned on in database. | + | * search_normalize(text) - Modified wrapper function to check if flag was turned on in database. |
- | - search_normalize(text, | + | |
- | - get_internal_flag - New stored procedure added. Takes a line of text representing the name field for the config.internal_flag table. Returns the enabled field of the matching name. | + | * search_normalize(text, |
- | - oils_tsearch2 - Modified the way the tsearch2 reads in new ts_vectors. Now normalizes the value before throwing it into to_tsvector(). | + | |
- | - config.altered_search_normalize - New trigger function added to handle updating meta data when flag is changed inside internal_flag table. | + | * get_internal_flag - New stored procedure added. Takes a line of text representing the name field for the config.internal_flag table. Returns the enabled field of the matching name. |
+ | |||
+ | * oils_tsearch2 - Modified the way the tsearch2 reads in new ts_vectors. Now normalizes the value before throwing it into to_tsvector(). | ||
+ | |||
+ | * config.altered_search_normalize - New trigger function added to handle updating meta data when flag is changed inside internal_flag table. | ||
The following tables have been modified: | The following tables have been modified: | ||
- | - config.internal_flag - Added row to handle altered search normalization rules. | ||
- | ==== Pull Request ==== | + | * config.internal_flag - Added row to handle altered search normalization rules. |
==== Blue Print ==== | ==== Blue Print ==== | ||
+ | https:// | ||
==== Deliverable ==== | ==== Deliverable ==== | ||
- | - Am option to alter search normalization functionality. | + | * An option to alter search normalization functionality. |
dev/proposal/search_normalization.1353946316.txt.gz · Last modified: 2022/02/10 13:34 (external edit)