Package: postgresql-16-prefix Source: prefix Version: 1.2.11-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 117 Depends: postgresql-16, libc6 (>= 2.14) Breaks: postgresql-16-jit-llvm (<< 21) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-16-prefix_1.2.11-1.pgdg26.04+1_amd64.deb Size: 41252 SHA512: 9d3712782cbbbad1cc9f10b07a18527f86ade0f526f8a4a7d2eaaeb44428aea8075810c45c4e94b8e86361e48e955a9fd3aeaa48d33a8c20a5ac70374136ab93 SHA256: 59db12e77be46963d2a0fb0ff788466793a7099e0071909cb029d84d83a51b5e SHA1: a2782df353221778b740ece463e3c70359bbb653 MD5sum: fd09d65f707e96f2ecb63433ca0d886f 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.