Raw Package Information
Package: postgresql-9.5-prefix
Source: prefix
Version: 1.2.9-3.pgdg20.04+1
Architecture: amd64
Maintainer: Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org>
Installed-Size: 77
Depends: libc6 (>= 2.14), postgresql-9.5
Priority: optional
Section: database
Filename: pool/main/p/prefix/postgresql-9.5-prefix_1.2.9-3.pgdg20.04+1_amd64.deb
Size: 22980
SHA256: 220fb2a00b081d0dc861523c96c1d8b0858ffe0c5acbc5678d88ee0421c24b94
SHA1: f69705814b85b7a372982d5d29070d926446d444
MD5sum: bf6153b5f7e22bfbca06db386a84f71b
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.