Package: postgresql-11-prefix Source: prefix Version: 1.2.11-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 123 Depends: postgresql-11, libc6 (>= 2.14) Breaks: postgresql-11-jit-llvm (<< 15) Homepage: https://github.com/dimitri/prefix Priority: optional Section: database Filename: pool/main/p/prefix/postgresql-11-prefix_1.2.11-1.pgdg22.04+1_amd64.deb Size: 45428 SHA512: 553d0b65b881f160ea6dda91a669ee5129d5ba6858ad2d0246ff7ba31fc2d33a25712cb733eab38fed938b56897ddb48e697655ccc577c146d0b438bce8c8687 SHA256: 594a414ad370a4b589f3d300b680ede3cb2a1c04599b0c1c75766f3bd89929e9 SHA1: 9302b64f666cc80ec53776d548b8c21ff2455c81 MD5sum: 6d420c00291d3762ad591220cbbcc75f 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.