Package: postgresql-9.4-prefix Source: prefix Version: 1.2.9-2.pgdg18.04+1 Architecture: i386 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 76 Depends: libc6 (>= 2.4), postgresql-9.4 Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-9.4-prefix_1.2.9-2.pgdg18.04+1_i386.deb Size: 24920 SHA256: ac4581cc5eceb03098a975a1a5cc9e4bc93cf0cd8f8033024db7f2c389a446d5 SHA1: 89eb87be52904fbc2a90fd4cb24eb9d00c068754 MD5sum: 53c800182f535d4066de1160a0a25ffc 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.