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