Package: postgresql-18-prefix Source: prefix Version: 1.2.11-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 121 Depends: postgresql-18, libc6 (>= 2.14) Breaks: postgresql-18-jit-llvm (<< 15) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-18-prefix_1.2.11-1.pgdg22.04+1_amd64.deb Size: 43904 SHA512: 5634496ad59397fb64d304128fb08287035a4fb0206cf2abbc859950c6b8b68df18b85dff7f6da5f77c6a641fe8deb93f79458da2691f3e9b44d434dfeeffaf8 SHA256: a7c9930a168a392592979cdcad880c3124472ecab3961ecb92a2c265e3a7554b SHA1: 5fb1f2caf42bf8606b85942b4cd74d5cd59654a7 MD5sum: f64f12cf6b945664bd602ab03854a9f5 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.