postgresql-9.6-prefix_1.2.5-1_i386.deb


Advertisement

Description

postgresql-9.6-prefix - Prefix Range module for PostgreSQL

Property Value
Distribution Ubuntu 17.10 (Artful Aardvark)
Repository Ubuntu Universe i386
Package name postgresql-9.6-prefix
Package version 1.2.5
Package release 1
Package architecture i386
Package type deb
Installed size 76 B
Download size 22.90 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.6-prefix_1.2.5-1_amd64.deb 1.2.5 amd64 Ubuntu Universe
postgresql-9.6-prefix - - -

Requires

Name Value
libc6 >= 2.4
postgresql-9.6 -

Download

Type URL
Binary Package postgresql-9.6-prefix_1.2.5-1_i386.deb
Source Package prefix

Install Howto

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

Files

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

Changelog

2016-09-24 - Christoph Berg <myon@debian.org>
prefix (1.2.5-1) unstable; urgency=medium
* New upstream version with 9.6 support.
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)

See Also

Package Description
postgresql-9.6-preprepare_0.8-1_i386.deb pre prepare your PostgreSQL statements server side
postgresql-9.6-prioritize_1.0.4-1.3_i386.deb Get and set the nice priorities of PostgreSQL backends
postgresql-9.6-python-multicorn_1.3.3-2ubuntu2_i386.deb multicorn extension for Postgres 9.6 to write FDWs with python2
postgresql-9.6-python3-multicorn_1.3.3-2ubuntu2_i386.deb multicorn extension for Postgres 9.6 to write FDWs with python3
postgresql-9.6-repack_1.3.4-3_i386.deb reorganize tables in PostgreSQL databases with minimal locks
postgresql-9.6-repmgr_3.3.1-1_i386.deb replication manager for PostgreSQL 9.6
postgresql-9.6-slony1-2_2.2.5-2_i386.deb replication system for PostgreSQL: PostgreSQL 9.6 server plug-in
postgresql-9.6-unit_4.0_i386.deb SI Units for PostgreSQL
postgresql-all_9.6+184ubuntu1_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-1_i386.deb efficient PostgreSQL table content comparison and synchronization
postgresql-filedump_9.6.0-2_i386.deb Utility to format PostgreSQL files
postgresql-hll_2.7-2.1_i386.deb HyperLogLog extension for PostgreSQL
postgresql-mysql-fdw-doc_2.2.0-2_all.deb documentation for mysql-fdw
postgresql-plperl-9.6_9.6.5-1_i386.deb PL/Perl procedural language for PostgreSQL 9.6
Advertisement
Advertisement