Package: postgresql-17-prefix Source: prefix Version: 1.2.11-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 117 Depends: postgresql-17, libc6 (>= 2.14) Breaks: postgresql-17-jit-llvm (<< 21) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-17-prefix_1.2.11-1.pgdg26.04+1_amd64.deb Size: 41236 SHA512: ba621867d4940a4221eea8693a3c461bd66c3865ec5564773498a5c8152b0ab3c2d96f550352885bb377faec53b027b4c1b8f9c706386f5ac0e7a37367750182 SHA256: 6656e0ab059c729858ddacb71c1013d38d92a2a0b09bb93c897ef6c0fcba94ca SHA1: 75cc3084ce6638473ceacefb52671fa4fbc66dd4 MD5sum: 91d2d3fe91fcad6ff9a5f7560479d572 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.