Package: postgresql-10-prefix Source: prefix Version: 1.2.11-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 77 Depends: postgresql-10, libc6 (>= 2.14) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-10-prefix_1.2.11-1.pgdg22.04+1_amd64.deb Size: 22288 SHA512: 2abb796c43c73e1c9e1bf95fb0cc18c713ee29d2c2e9ee117b6de9c7dac2eef05c54287f245fe75cdf46923d7b7399718d6935a284c2705de088e95d8b9235de SHA256: 77a5d1d278b5b9a699043ba313210425a7f1f485f1034741ee86847bf45e37a9 SHA1: cb7c184d0a0ad267751c6807ef0404dea0f6d3fa MD5sum: ec43bee8ac434c8546b488de11b9c965 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.