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