Package: postgresql-14-prefix Source: prefix Version: 1.2.11-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 117 Depends: postgresql-14, libc6 (>= 2.14) Breaks: postgresql-14-jit-llvm (<< 21) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-14-prefix_1.2.11-1.pgdg26.04+1_amd64.deb Size: 41144 SHA512: 37e865c2dc2355bb175af6786b7f6eaa2198d923aa6916214235437ce4b6e1a3b17e4ce067cf184aa5c4afbb217d88af70aaaac3869e0cbd53d6ef2cce9770af SHA256: 42a56f94ed630caf8f9a60dd0b97fff1bdabd5cd00ade8f46b03654d6dc10965 SHA1: 31590b49503b1dc975ae8a86d2946b53c534ce1c MD5sum: 3865e584756251b9c3ca4083f63d71cb Description: Prefix Range module for PostgreSQL This PostgreSQL module provides the prefix_range datatype, allowing to index searches such as finding the longest prefix matching a telephone number, having prefixes in a table and telephone number as a parameter: . select * from prefixes where prefix @> '0100091234'; . The prefix column has to be of type prefix_range, and any text field can get indexed by the provided GiST opclass.