Package: postgresql-10-prefix Source: prefix Version: 1.2.9-3.pgdg20.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 77 Depends: libc6 (>= 2.14), postgresql-10 Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-10-prefix_1.2.9-3.pgdg20.04+1_amd64.deb Size: 22952 SHA256: 09581abd30c546d5919d5c2a52da47985f66a756cb8365c282cbfb6468d6f8d1 SHA1: 1bb85bf330a1505fa82b13c2433843ff83912dae MD5sum: 42a8171dbfddb3eb369927bc051c8663 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.