Package: postgresql-17-prefix Source: prefix Version: 1.2.11-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 122 Depends: postgresql-17, libc6 (>= 2.14) Breaks: postgresql-17-jit-llvm (<< 15) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-17-prefix_1.2.11-1.pgdg22.04+1_amd64.deb Size: 44748 SHA512: a76e8335955e41e5a62888c94dc2c2869ce1e20711608048334b11cc6db799d24abce09d4a0331928555eba9bb283875f6dfbf639fab773fdea70ac655eb06d2 SHA256: 1d446b968ff4af470cc50c852cd283b175defbe3d2f9a8cf93a712f212e68bdc SHA1: 63af39e7399e2a848f797f0738a6ef5c20d36609 MD5sum: 7ff0bfc88570affbb376bdc02929435d 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.