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