Home » Catalog » Debian » powerpc » database »

postgresql-8.4-prefix

Prefix Range module for PostgreSQL

Variants:

This PostgreSQL module provides the prefix_range datatype, which allows 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.

Homepage:	-
Package version:	1.1.0-1.1
Architecture:	powerpc
Distribution:	Debian
Filename:	postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb

/usr/share/doc/postgresql-8.4-prefix/README.txt.gz

= Prefix Opclass

This module is written by Dimitri Fontaine with a great amount of help
from RhodiumToad (formely known as AndrewSN), who was the one advising
for a 'GiST opclass' to solve the prefix matching problem.

== Presentation

Prefix matching is both very common and important in telephony
applications, where call routing and costs depend on matching
caller/callee phone number to an opera
more»

/usr/share/doc/postgresql-8.4-prefix/changelog.Debian.gz

prefix (1.1.0-1.1) unstable; urgency=low

  * Non-maintainer upload.
  * debian/{control, postgresql-8.3*, rules}
    - support only PostgreSQL 8.4, dropping support for 8.3; thanks to Martin
      Pitt for the report; Closes: #559610

 -- Sandro Tosi <morph@debian.org>  Thu, 18 Feb 2010 14:22:54 +0100

prefix (1.1.0-1) unstable; urgency=high

  * Fix Btree opclass for supporting sub-ranges

 -- D
more»

/usr/share/doc/postgresql-8.4-prefix/copyright

This package was debianized by Dimitri Fontaine <dim@tapoueh.org> on
Tue, 22 Apr 2008 11:42:09 +0200.

It was downloaded from http://pgfoundry.org/projects/prefix/

Copyright Holders:

 Copyright (c) 2008 - Dimitri Fontaine <dim@tapoueh.org>

License:

This code is available under the terms of the BSD license.  On Debian
GNU/Linux systems, the complete text of the BSD license can be found in
/usr/
more»

Browse inside postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb

		[DIR]	DEBIAN/ (2) 65535+ mirrors
		[DIR]	usr/ (2) 65535+ mirrors

Download postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb

2010-02-22 ftp://ftp.nl.debian.org/…main/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://ftp.ticklers.org/…/main/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://mirror.us.oneandone.net/…/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://ftp.sunet.se/…pool/main/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://ftp.sunet.se/…pool/main/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://ftp.iinet.net.au/…/main/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://ftp.wantree.com.au/…ain/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://mirrors.kernel.org/…ain/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://mirrors.kernel.org/…ain/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://mirrors.st.uz/…ool/main/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://mirrors.fe.up.pt/…/main/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://koyanet.lv/…n/pool/main/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://linux.mathematik.tu-darmstadt.de/…postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://grolela.estig.ipb.pt/…n/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
2010-02-22 ftp://46.30.211.12/…pool/main/p/prefix/postgresql-8.4-prefix_1.1.0-1.1_powerpc.deb
more download mirrors»