Package: postgresql-12-prefix Source: prefix Version: 1.2.11-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 76 Depends: postgresql-12, libc6 (>= 2.14) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-12-prefix_1.2.11-1.pgdg26.04+1_amd64.deb Size: 20736 SHA512: 9c4f00e674c382e46f714682e0b2340fdcbe15a55829361470cb42eb7158c71308849e963f80833df7c73db6901d7efc5d923fbe74035219c6bc9c0ee3ccac8f SHA256: 9a4e3c98d7310b01f42e74563e82b9918f13ba5201d2bde3398fd83a0803dece SHA1: 1c9b5e72a7b2dba787d5989259cd748f1470d37b MD5sum: 7981d00aa6bf32b5cbef16b124ac894c 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.