Package: postgresql-12-prefix Source: prefix Version: 1.2.9-5.pgdg18.04+1 Architecture: i386 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 119 Depends: postgresql-12, libc6 (>= 2.4) Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-12-prefix_1.2.9-5.pgdg18.04+1_i386.deb Size: 45812 SHA256: 755213c8ea7a8c7d3b8bfbed2a4abdd292bddb2d135347320b32b3d04c7910c1 SHA1: 7031fb2952881d83a43a73e5fb3e0aa5268687f3 MD5sum: 806e0a63389825d7ce348c207729749b 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.