Package: postgresql-11-prefix Source: prefix Version: 1.2.11-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 76 Depends: postgresql-11, libc6 (>= 2.14) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-11-prefix_1.2.11-1.pgdg26.04+1_amd64.deb Size: 20800 SHA512: 7bdf679e6be527a62237a938f787a84cad6e6dee56f7f3837fc6b68011c5fdca0e2b8a740509a892d64d6a36398c245d6a0d175459350c386643f95ae2a010a7 SHA256: 2657168d615048510f4762c3ec8a77d2a5a9fa53c93f769e6a53e7954de1d569 SHA1: 9505565bd777d536de3600a1d14977a366e12329 MD5sum: 547abaf4388d9a37e611c19ab4ab56eb 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.