Package: postgresql-18-prefix Source: prefix Version: 1.2.10-4.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 121 Depends: postgresql-18, libc6 (>= 2.14) Breaks: postgresql-18-jit-llvm (<< 15) Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-18-prefix_1.2.10-4.pgdg22.04+1_amd64.deb Size: 43908 SHA256: db6fa332e2391673b7d7f3cdc6cc0e7ef0c44c0673d3509c5ca2a0edb35cbefe SHA1: 979737cc8a9692b33aecd8abf43d3c2741080fea MD5sum: 97638a1b7a7715eaf8d2fd13e56db584 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.