Package: postgresql-10-prefix Source: prefix Version: 1.2.11-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 76 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.pgdg26.04+1_amd64.deb Size: 20640 SHA512: 1bd517e1a534582a021a77e6bd256806120197708a4e66f2b180d3701c8003dc161f5d4b4ca07dc251cbf2ee68f68a20fa39acb41877149d209cf43a510fd059 SHA256: 34836fee523181a18eed9ee7b7a338a2a362472609a0af9ea87b0e9cf71c6929 SHA1: eba7648eeb1544846797f2e8766ff5527b0bdc90 MD5sum: 245877ee5cce2b96e7a06dc3ffecc59b 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.