Package: postgresql-18-prefix Source: prefix Version: 1.2.11-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 117 Depends: postgresql-18, libc6 (>= 2.14) Breaks: postgresql-18-jit-llvm (<< 21) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-18-prefix_1.2.11-1.pgdg26.04+1_amd64.deb Size: 41120 SHA512: 24420802b1e232aaab809820548c3e7527b76f0a11cb7131e5e1e3d5e326de07bb475aef10c878ce149976a985b87aee37c1beb1aecd0ee913d80e2a4cc14afb SHA256: c5d17daa311888f7b3634eb744e198d165119c31ad5a2abd2aebc19e93344970 SHA1: 75b5a123df2215e074ce5a3d4e259706d8208469 MD5sum: 3fa7d961f2a0442cb224d7310610e466 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.