Package: postgresql-15-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-15, postgresql-15-jit-llvm (>= 14) Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-15-prefix_1.2.10-2.pgdg22.04+1_amd64.deb Size: 45008 SHA256: 95bb2942d83b1e10d8b405947774c3df2abe45ff55ee007af9321dc99da36a02 SHA1: 62f284790ddacd81702df7f30619d6d05235914e MD5sum: c6b00d94a4a4b2795631652fb66a32d0 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.