postgresql-10-prefix - Prefix Range module for PostgreSQL

Property Value
Distribution Ubuntu 18.04 LTS (Bionic Beaver)
Repository Ubuntu Universe i386
Package filename postgresql-10-prefix_1.2.7-1_i386.deb
Package name postgresql-10-prefix
Package version 1.2.7
Package release 1
Package architecture i386
Package type deb
Category universe/database
Homepage -
License -
Maintainer Ubuntu Developers <>
Download size 23.28 KB
Installed size 76.00 KB
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.


Package Version Architecture Repository
postgresql-10-prefix_1.2.7-1_amd64.deb 1.2.7 amd64 Ubuntu Universe
postgresql-10-prefix - - -


Name Value
libc6 >= 2.4
postgresql-10 -


Type URL
Binary Package postgresql-10-prefix_1.2.7-1_i386.deb
Source Package prefix

Install Howto

  1. Update the package index:
    # sudo apt-get update
  2. Install postgresql-10-prefix deb package:
    # sudo apt-get install postgresql-10-prefix




2018-02-05 - Christoph Berg <>
prefix (1.2.7-1) unstable; urgency=medium
* New upstream version, removing support for 8.x and fixing compatibility
with 10.x.
2017-09-26 - Christoph Berg <>
prefix (1.2.6-1) unstable; urgency=medium
* New upstream version.
* Upload to Debian with PostgreSQL 10 support.
* Bump DH compat to 9.
2016-09-24 - Christoph Berg <>
prefix (1.2.5-1) unstable; urgency=medium
* New upstream version with 9.6 support.
2016-01-09 - Christoph Berg <>
prefix (1.2.4-1) unstable; urgency=medium
* New upstream version with 9.5 support.
2014-07-27 - Christoph Berg <>
prefix (1.2.3-3) unstable; urgency=medium
* Upload to unstable for 9.4.
2014-07-05 - Christoph Berg <>
prefix (1.2.3-2) experimental; urgency=medium
* B-D on pg-common 158 to build against 9.3 and 9.4.
* Remove needs-root restriction from tests.
2014-06-15 - Christoph Berg <>
prefix (1.2.3-1) unstable; urgency=medium
* Update expected/explain_1.out (9.0 variant) for the latest changes.
* Use pg_buildext installcheck.
* Set team as maintainer.
2014-01-26 - Christoph Berg <>
prefix (1.2.2-1) unstable; urgency=medium
* New upstream release
+ Allows building on 9.4+.
+ Regression test updates.
* Add make to the test dependencies.
2013-02-26 - Christoph Berg <>
prefix (1.2.1-1) unstable; urgency=low
* debian/rules: Use "pg_buildext loop".
* Use "all" in debian/pgversions and B-D on pg-server-dev >= 148.
* Add regression tests and run them using autopkgtest.
* Add watch file.
* Add myself to Uploaders.
2012-10-15 - Dimitri Fontaine <>
prefix (1.2.0-1) experimental; urgency=low
[ Dimitri Fontaine ]
* Fix GiST consisten function in non-leaf nodes (Closes: #690160)
* Refactors as a real PostgreSQL Extension
* Add explicit compatibility with PostgreSQL 9.2 and 9.3devel
[ Christoph Berg ]
* Add Vcs headers
* Upload to experimental

See Also

Package Description
postgresql-10-preprepare_0.9-1_i386.deb pre prepare your PostgreSQL statements server side
postgresql-10-prioritize_1.0.4-3_i386.deb Get and set the nice priorities of PostgreSQL backends
postgresql-10-python-multicorn_1.3.4-1_i386.deb multicorn extension for Postgres 10 to write FDWs with python2
postgresql-10-python3-multicorn_1.3.4-1_i386.deb multicorn extension for Postgres 10 to write FDWs with python3
postgresql-10-repack_1.4.2-2_i386.deb reorganize tables in PostgreSQL databases with minimal locks
postgresql-10-repmgr_4.0.3-1_i386.deb replication manager for PostgreSQL 10
postgresql-10-rum_1.2.0-1_i386.deb PostgreSQL RUM access method
postgresql-10-similarity_1.0~20160916-1_i386.deb PostgreSQL similarity functions extension
postgresql-10-slony1-2_2.2.6-1_i386.deb replication system for PostgreSQL: PostgreSQL 10 server plug-in
postgresql-10-unit_5.0-1_i386.deb SI Units for PostgreSQL
postgresql-all_10+190_all.deb metapackage depending on all PostgreSQL server packages
postgresql-autodoc_1.40-3_all.deb Utility to create a PostgreSQL database schema overview in HTML, DOT and XML
postgresql-comparator_2.3.0-2_i386.deb efficient PostgreSQL table content comparison and synchronization
postgresql-filedump_10.0-1build1_i386.deb Utility to format PostgreSQL files
postgresql-hll_2.7-2.1_i386.deb HyperLogLog extension for PostgreSQL