postgresql-9.4-prefix_1.2.3-3_i386.deb


Advertisement

Description

postgresql-9.4-prefix - Prefix Range module for PostgreSQL

Property Value
Distribution Debian 8 (Jessie)
Repository Debian Main i386
Package name postgresql-9.4-prefix
Package version 1.2.3
Package release 3
Package architecture i386
Package type deb
Installed size 51 B
Download size 18.44 KB
Official Mirror ftp.br.debian.org
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.4-prefix_1.2.3-3_amd64.deb 1.2.3 amd64 Debian Main
postgresql-9.4-prefix - - -

Requires

Name Value
libc6 >= 2.1.3
postgresql-9.4 -

Download

Type URL
Binary Package postgresql-9.4-prefix_1.2.3-3_i386.deb
Source Package prefix

Install Howto

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

Files

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

Changelog

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
2009-10-06 - Dimitri Fontaine <dim@tapoueh.org>
prefix (1.0.0-1) unstable; urgency=low
* Release 1.0.0
* unset DEBUG in prefix.c
* penalty only barfs about non digit if DEBUG_PENALTY is set

See Also

Package Description
postgresql-9.4-preprepare_0.7-2_i386.deb pre prepare your PostgreSQL statements server side
postgresql-9.4-python-multicorn_1.0.4-1_i386.deb multicorn extension for Postgres 9.4 to write FDWs with python2
postgresql-9.4-python3-multicorn_1.0.4-1_i386.deb multicorn extension for Postgres 9.4 to write FDWs with python3
postgresql-9.4-repmgr_2.0-3_i386.deb replication manager support modules for PostgreSQL 9.4
postgresql-9.4-slony1-2_2.2.3-1_i386.deb replication system for PostgreSQL: PostgreSQL 9.4 server plug-in
postgresql-9.4_9.4.18-0+deb8u1_i386.deb object-relational SQL database, version 9.4 server
postgresql-autodoc_1.40-3_all.deb Utility to create a PostgreSQL database schema overview in HTML, DOT and XML
postgresql-client-9.4_9.4.18-0+deb8u1_i386.deb front-end programs for PostgreSQL 9.4
postgresql-client-common_165+deb8u3_all.deb manager for multiple PostgreSQL client versions
postgresql-client_9.4+165+deb8u3_all.deb front-end programs for PostgreSQL (supported version)
postgresql-common_165+deb8u3_all.deb PostgreSQL database-cluster manager
postgresql-comparator_2.2.5-2_i386.deb efficient PostgreSQL table content comparison and synchronization
postgresql-contrib-9.4_9.4.18-0+deb8u1_i386.deb additional facilities for PostgreSQL
postgresql-contrib_9.4+165+deb8u3_all.deb additional facilities for PostgreSQL (supported version)
postgresql-doc-9.4_9.4.18-0+deb8u1_all.deb documentation for the PostgreSQL database management system
Advertisement
Advertisement