Package: postgresql-13-prefix Source: prefix Version: 1.2.11-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 76 Depends: postgresql-13, libc6 (>= 2.14) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-13-prefix_1.2.11-1.pgdg26.04+1_amd64.deb Size: 20700 SHA512: f008046af2a32c0def8deeeff82c477a95a61879b8a89dea8e1c2cfdb1f1e089dba195240f1f9e4594a87481254e1c3ff7af7587bc23190fa9173b9a2391722c SHA256: baf93c39132534f6d690bdeeaca7011e9dec10d4c3cc3e2ea15cac1f81f13b2b SHA1: 8423d04e798d28b7efe300fb0cbf11f27e149e5f MD5sum: de2bd0a02a33c3f24f0ca65b6d012342 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.