Package: postgresql-11-prefix Source: prefix Version: 1.2.9-5.pgdg18.04+1 Architecture: i386 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 119 Depends: postgresql-11, libc6 (>= 2.4) Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-11-prefix_1.2.9-5.pgdg18.04+1_i386.deb Size: 45704 SHA256: 5fca1d9b1c4cf6d3bcf21fe87288d110504c77c2f157c727b497c769a3809339 SHA1: 19eb173fd370044d9c23ea69b3054957ff9a3c09 MD5sum: 81c02a1171eba3ffe04ac724e7194db8 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.