Package: postgresql-14-prefix Source: prefix Version: 1.2.11-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 123 Depends: postgresql-14, libc6 (>= 2.14) Breaks: postgresql-14-jit-llvm (<< 15) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-14-prefix_1.2.11-1.pgdg22.04+1_amd64.deb Size: 45064 SHA512: ca13dd74f391bb22ad1096b7200b22b4df88369307a58fd217fe7986301be45dbb4d90b6d50316dedec33404eb293831b6b28a5c92180b4112a0dbbd3abbae73 SHA256: d164bb3f20ae2f5f731798d32f780a9c8e8aeab423a9c8247c22852ff04b57ae SHA1: f591db3585e1a3d17aef177c6b7a4ae5dbfc1218 MD5sum: fd5b503b15f8dd94a6cb32af0a0b4b6e 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.