Package: postgresql-16-prefix Source: prefix Version: 1.2.11-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 122 Depends: postgresql-16, libc6 (>= 2.14) Breaks: postgresql-16-jit-llvm (<< 15) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-16-prefix_1.2.11-1.pgdg22.04+1_amd64.deb Size: 44812 SHA512: 61175ada4b2cf10d6b4004e33960ebc72fec1ab748e6ffeeb6e0efbf9d3fab883f0537c7c352e04e86a19eadcfb78e248127a36b4fde0361ec7de02bdb37a7cc SHA256: c45965340d8cdbfa4f1c977bd2e638851094f9f7cde658c60f75f3c6b6f897f9 SHA1: 91b6cd398324749eb0cd5c4c7a8e31d620461975 MD5sum: 8df655904d591f344b22f03687c7ab92 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.