Package: postgresql-11-prefix Source: prefix Version: 1.2.10-2.pgdg20.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 124 Depends: libc6 (>= 2.14), postgresql-11, postgresql-11-jit-llvm (>= 10) Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-11-prefix_1.2.10-2.pgdg20.04+1_amd64.deb Size: 46412 SHA256: a5433ef11f4896bbd6c22bb0d5219072fc50b673334926545c285a56610f5eb0 SHA1: 92852803020c18a66a27e11118ed3325bbefb21d MD5sum: 86adcf8f912c84ffe0f016633d886fa0 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.