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