From 311bcfc6b3acdd6fd152798c7f287ddf74fa2a98 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Tue, 16 Apr 2024 21:46:48 +0200 Subject: Adding upstream version 15.4. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/dict-int.html | 62 +++++++++++++++++++++++++++++++++++++++++ 1 file changed, 62 insertions(+) create mode 100644 doc/src/sgml/html/dict-int.html (limited to 'doc/src/sgml/html/dict-int.html') diff --git a/doc/src/sgml/html/dict-int.html b/doc/src/sgml/html/dict-int.html new file mode 100644 index 0000000..cc2ba91 --- /dev/null +++ b/doc/src/sgml/html/dict-int.html @@ -0,0 +1,62 @@ + +F.13. dict_int
F.13. dict_int
Prev UpAppendix F. Additional Supplied ModulesHome Next

F.13. dict_int

F.13.1. Configuration
F.13.2. Usage

+ dict_int is an example of an add-on dictionary template + for full-text search. The motivation for this example dictionary is to + control the indexing of integers (signed and unsigned), allowing such + numbers to be indexed while preventing excessive growth in the number of + unique words, which greatly affects the performance of searching. +

+ This module is considered “trusted”, that is, it can be + installed by non-superusers who have CREATE privilege + on the current database. +

F.13.1. Configuration

+ The dictionary accepts three options: +

  • + The maxlen parameter specifies the maximum number of + digits allowed in an integer word. The default value is 6. +

  • + The rejectlong parameter specifies whether an overlength + integer should be truncated or ignored. If rejectlong is + false (the default), the dictionary returns the first + maxlen digits of the integer. If rejectlong is + true, the dictionary treats an overlength integer as a stop + word, so that it will not be indexed. Note that this also means that + such an integer cannot be searched for. +

  • + The absval parameter specifies whether leading + “+” or “-” + signs should be removed from integer words. The default + is false. When true, the sign is + removed before maxlen is applied. +

F.13.2. Usage

+ Installing the dict_int extension creates a text search + template intdict_template and a dictionary intdict + based on it, with the default parameters. You can alter the + parameters, for example + +

+mydb# ALTER TEXT SEARCH DICTIONARY intdict (MAXLEN = 4, REJECTLONG = true);
+ALTER TEXT SEARCH DICTIONARY
+

+ + or create new dictionaries based on the template. +

+ To test the dictionary, you can try + +

+mydb# select ts_lexize('intdict', '12345678');
+ ts_lexize
+-----------
+ {123456}
+

+ + but real-world usage will involve including it in a text search + configuration as described in Chapter 12. + That might look like this: + +

+ALTER TEXT SEARCH CONFIGURATION english
+    ALTER MAPPING FOR int, uint WITH intdict;
+

+ +

Prev Up Next
dblink_build_sql_update Home F.14. dict_xsyn
\ No newline at end of file -- cgit v1.2.3