Package: postgresql-11-prefix Source: prefix Version: 1.2.10-4.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 123 Depends: postgresql-11, libc6 (>= 2.14) Breaks: postgresql-11-jit-llvm (<< 15) Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-11-prefix_1.2.10-4.pgdg22.04+1_amd64.deb Size: 45332 SHA256: fcc1e0eba7743bf7dc6a17755096e3fe08d1eabb6c6825b83b6adfb1b8a08680 SHA1: 9437d61d7bb2e6a353ac0bcfc47b0c9e1c1b33c0 MD5sum: 23544d072574023bf33c200a9e831b43 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.