From 97c40ce61465582b96944e41ed6ec06c2016b95c Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 30 Jun 2014 20:51:26 -0400 Subject: Allow empty replacement strings in contrib/unaccent. This is useful in languages where diacritic signs are represented as separate characters; it's also one step towards letting unaccent be used for arbitrary substring substitutions. In passing, improve the user documentation for unaccent, which was sadly vague about some important details. Mohammad Alhashash, reviewed by Abhijit Menon-Sen --- doc/src/sgml/unaccent.sgml | 36 +++++++++++++++++++++++++++++++----- 1 file changed, 31 insertions(+), 5 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/unaccent.sgml b/doc/src/sgml/unaccent.sgml index af9cad5d8c7..aef0031dcbc 100644 --- a/doc/src/sgml/unaccent.sgml +++ b/doc/src/sgml/unaccent.sgml @@ -45,9 +45,9 @@ - Each line represents a pair, consisting of a character with accent - followed by a character without accent. The first is translated into - the second. For example, + Each line represents one translation rule, consisting of a character with + accent followed by a character without accent. The first is translated + into the second. For example, À A Á A @@ -57,6 +57,27 @@ Å A Æ A + The two characters must be separated by whitespace, and any leading or + trailing whitespace on a line is ignored. + + + + + + Alternatively, if only one character is given on a line, instances of + that character are deleted; this is useful in languages where accents + are represented by separate characters. + + + + + + As with other PostgreSQL text search configuration files, + the rules file must be stored in UTF-8 encoding. The data is + automatically translated into the current database's encoding when + loaded. Any lines containing untranslatable characters are silently + ignored, so that rules files can contain rules that are not applicable in + the current encoding. @@ -132,8 +153,8 @@ mydb=# select ts_headline('fr','Hôtel de la Mer',to_tsquery('fr','Hotels') The unaccent() function removes accents (diacritic signs) from - a given string. Basically, it's a wrapper around the - unaccent dictionary, but it can be used outside normal + a given string. Basically, it's a wrapper around + unaccent-type dictionaries, but it can be used outside normal text search contexts. @@ -145,6 +166,11 @@ mydb=# select ts_headline('fr','Hôtel de la Mer',to_tsquery('fr','Hotels') unaccent(dictionary, string) returns text + + If the dictionary argument is + omitted, unaccent is assumed. + + For example: -- cgit v1.2.3