Package: postgresql-11-prefix Source: prefix Version: 1.2.11-1.pgdg26.04+2 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+2_amd64.deb Size: 20812 SHA512: 2cb3eefba0eba9bd53365be7ff5d628ce4f0e8d32a01fdfbabe30f6e74590a6f8cf18e03f8c9bf0470d14b87429139f26c1018d2e3eefda5c03b4dd5c681dc42 SHA256: 7c2bf884136707cb51de38a438354d57ee3ee981ac9bf884c74c8c55893c8f58 SHA1: 55ccdd09ceab10f371de53e23725cf13ba39110f MD5sum: 5472e8b031709e20ae16f95aa27ea450 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.