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