dict_int

dict_int : text search dictionary template for integers

Overview

ID	Extension	Package	Version	Category	License	Language
4980	dict_int	dict_int	`1.0`	FUNC	PostgreSQL	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-dt-	No	Yes	No	Yes	no	yes

Relationships
See Also	dict_xsyn unaccent pg_similarity smlar pg_summarize pg_search pgroonga pg_bigm

Packages

PG18	PG17	PG16	PG15	PG14
1.0	1.0	1.0	1.0	1.0

This is a built-in contrib extension ship with the PostgreSQL kernel

Install

Create this extension with:

CREATE EXTENSION dict_int;

Usage

dict_int: integer text search dictionary

Controls the indexing of integers in full-text search to prevent excessive unique-word growth that degrades search performance.

CREATE EXTENSION dict_int;

Configuration Parameters

Parameter	Description	Default
`maxlen`	Maximum number of digits allowed	6
`rejectlong`	If `true`, reject overlength integers (stop word). If `false`, truncate.	`false`
`absval`	If `true`, strip leading `+`/`-` before applying maxlen	`false`

Examples

-- Test the default dictionary
SELECT ts_lexize('intdict', '12345678');
-- {123456}  (truncated to 6 digits by default)

-- Configure to reject long integers
ALTER TEXT SEARCH DICTIONARY intdict (MAXLEN = 4, REJECTLONG = true);
SELECT ts_lexize('intdict', '12345');
-- {}  (rejected as stop word)

SELECT ts_lexize('intdict', '1234');
-- {1234}  (accepted)

-- Apply to a text search configuration
ALTER TEXT SEARCH CONFIGURATION english
  ALTER MAPPING FOR int, uint WITH intdict;

Last updated on 2026-03-12

intagg unaccent