Package: postgresql-14-prefix Source: prefix Version: 1.2.10-2.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 123 Depends: libc6 (>= 2.14), postgresql-14, postgresql-14-jit-llvm (>= 14) Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-14-prefix_1.2.10-2.pgdg22.04+1_amd64.deb Size: 45056 SHA256: 97cc171ae59197bec5f97412513261c943db9e26424c14272f2783c0740b3d07 SHA1: 1f0b79b6f8981354374082fa88718d7d93e8083a MD5sum: 2e46500ca4cd4cf740a7cb102614f3a2 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.