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