Package: postgresql-13-prefix Source: prefix Version: 1.2.11-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 123 Depends: postgresql-13, libc6 (>= 2.14) Breaks: postgresql-13-jit-llvm (<< 15) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-13-prefix_1.2.11-1.pgdg22.04+1_amd64.deb Size: 44868 SHA512: 4fa64e5a718cd5edb18b3131e6d6c553eb180c6544b37f40cb44c87ad64ff7d723d8d9fb588186ce93d329020517820ce8c106f5f064ae8bb0aa85ac33ff2393 SHA256: d7a061d9ec4df307eb9cbfd7e839e247599299b8db1dd1594a0da3c94388e87e SHA1: 528966e6415e805f55abb141e35d3627081296e3 MD5sum: a2309789596eb34fd39a0f378ae20d33 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.