Package: postgresql-18-prefix Source: prefix Version: 1.2.10-3.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 121 Depends: postgresql-18, libc6 (>= 2.14) Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-18-prefix_1.2.10-3.pgdg22.04+1_amd64.deb Size: 43884 SHA256: fab11fd347117e5350fe6ca3dcb4993d1673d3816677d4c2b40dfd566e5ca626 SHA1: 09e498486676acf0c07a7eb1dc2af72fcabf0a9a MD5sum: 98d32601865e9cfffaad104b367b4618 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.