postgresql-9.5-prefix_1.2.4-1_amd64.deb


Advertisement

Description

postgresql-9.5-prefix - Prefix Range module for PostgreSQL

Property Value
Distribution Ubuntu 16.04 LTS (Xenial Xerus)
Repository Ubuntu Universe amd64
Package name postgresql-9.5-prefix
Package version 1.2.4
Package release 1
Package architecture amd64
Package type deb
Installed size 68 B
Download size 17.60 KB
Official Mirror archive.ubuntu.com
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.

Alternatives

Package Version Architecture Repository
postgresql-9.5-prefix_1.2.4-1_i386.deb 1.2.4 i386 Ubuntu Universe
postgresql-9.5-prefix - - -

Requires

Name Value
libc6 >= 2.14
postgresql-9.5 -

Download

Type URL
Binary Package postgresql-9.5-prefix_1.2.4-1_amd64.deb
Source Package prefix

Install Howto

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

Files

Path
/usr/lib/postgresql/9.5/lib/prefix.so
/usr/share/doc/postgresql-9.5-prefix/README.md.gz
/usr/share/doc/postgresql-9.5-prefix/TESTS.md.gz
/usr/share/doc/postgresql-9.5-prefix/changelog.Debian.gz
/usr/share/doc/postgresql-9.5-prefix/copyright
/usr/share/postgresql/9.5/extension/prefix--1.1--1.2.0.sql
/usr/share/postgresql/9.5/extension/prefix--1.2.0.sql
/usr/share/postgresql/9.5/extension/prefix--unpackaged--1.2.0.sql
/usr/share/postgresql/9.5/extension/prefix.control

Changelog

2016-01-09 - Christoph Berg <myon@debian.org>
prefix (1.2.4-1) unstable; urgency=medium
* New upstream version with 9.5 support.
2014-07-27 - Christoph Berg <myon@debian.org>
prefix (1.2.3-3) unstable; urgency=medium
* Upload to unstable for 9.4.
2014-07-05 - Christoph Berg <myon@debian.org>
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 <myon@debian.org>
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 <myon@debian.org>
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 <myon@debian.org>
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 <dim@tapoueh.org>
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
2010-03-12 - Dimitri Fontaine <dim@tapoueh.org>
prefix (1.1.1-1) unstable; urgency=low
* Test against 9.0 and 9.1
* Package now supports 8.3 8.4 9.0 and 9.1 out of the box (Closes: #639479)
* Fix README to ORDER BY length DESC
* Fix a bug in intersect code, so that 123 & 123[4-5] is 123[4-5]
2010-01-11 - Dimitri Fontaine <dim@tapoueh.org>
prefix (1.1.0-2) unstable; urgency=low
* Support pgversions and pgxs_debian_control (Closes: #559610)
2009-11-30 - Dimitri Fontaine <dim@tapoueh.org>
prefix (1.1.0-1) unstable; urgency=high
* Fix Btree opclass for supporting sub-ranges

See Also

Package Description
postgresql-9.5-preprepare_0.7-3_amd64.deb pre prepare your PostgreSQL statements server side
postgresql-9.5-prioritize_1.0.4-1.2_amd64.deb Get and set the nice priorities of PostgreSQL backends
postgresql-9.5-python-multicorn_1.3.2-1_amd64.deb multicorn extension for Postgres 9.5 to write FDWs with python2
postgresql-9.5-python3-multicorn_1.3.2-1_amd64.deb multicorn extension for Postgres 9.5 to write FDWs with python3
postgresql-9.5-repmgr_3.0.3-2_amd64.deb replication manager for PostgreSQL 9.5
postgresql-9.5-slony1-2_2.2.4-3_amd64.deb replication system for PostgreSQL: PostgreSQL 9.5 server plug-in
postgresql-autodoc_1.40-3_all.deb Utility to create a PostgreSQL database schema overview in HTML, DOT and XML
postgresql-comparator_2.2.6-2_amd64.deb efficient PostgreSQL table content comparison and synchronization
postgresql-filedump_9.3.0-3_amd64.deb Utility to format PostgreSQL files
postgresql-hll_2.7-2.1_amd64.deb HyperLogLog extension for PostgreSQL
postgresql-mysql-fdw-doc_2.1.2-1build1_all.deb documentation for mysql-fdw
postgresql-plperl-9.5_9.5.2-1_amd64.deb PL/Perl procedural language for PostgreSQL 9.5
postgresql-plpython-9.5_9.5.2-1_amd64.deb PL/Python procedural language for PostgreSQL 9.5
postgresql-plpython3-9.5_9.5.2-1_amd64.deb PL/Python 3 procedural language for PostgreSQL 9.5
postgresql-pltcl-9.5_9.5.2-1_amd64.deb PL/Tcl procedural language for PostgreSQL 9.5
Advertisement
Advertisement