Package: postgresql-16-prefix Source: prefix Version: 1.2.10-3.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 123 Depends: postgresql-16, postgresql-16-jit-llvm (>= 15), libc6 (>= 2.14) Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-16-prefix_1.2.10-3.pgdg22.04+1_amd64.deb Size: 44940 SHA256: a3787c4af0a2c97db370a09dcfcc990be48454bbc42da23fd9491a2e268e3266 SHA1: 3f3a961ed2c6861616a142ea4e5289a32a465b31 MD5sum: 3d8d13e77ade87e2a6a1f9626f06c191 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.