Package: postgresql-17-prefix Source: prefix Version: 1.2.10-3.pgdg20.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 124 Depends: postgresql-17, postgresql-17-jit-llvm (>= 10), libc6 (>= 2.14) Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-17-prefix_1.2.10-3.pgdg20.04+1_amd64.deb Size: 46072 SHA256: 660b4698cef04b5b207af979d79f26db48567169765693be06a6b6bac5316fe4 SHA1: f9bcb289a05f1bdbf74ec8080b845d254134f576 MD5sum: cc792d03431ba821fb1318f1f4e6c925 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.