Package: postgresql-15-prefix Source: prefix Version: 1.2.11-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 123 Depends: postgresql-15, libc6 (>= 2.14) Breaks: postgresql-15-jit-llvm (<< 15) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-15-prefix_1.2.11-1.pgdg22.04+1_amd64.deb Size: 45012 SHA512: 959f6c7f0bccac989888fc48fabb9c1b076f2747d2e63eabd9016a76cd5a9e24806d64ca84b3d6c5437b6a9fab380c0239349a0d09ff7f78d833449fc01772f9 SHA256: 49b1480e091dc68e621e8537b1a868a98beeb14ff9e3d1e682e3bf00e9f20fc4 SHA1: 19ea96e573a3ff20698c6fccf24a0e7e1dd1e7d3 MD5sum: a70926baed464aeaed5ea529c7fd3343 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.