Filewatcher File Search File Search
Content Search
» » » » »


Prefix Range module for PostgreSQL

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.

Package version:1.1.0-1.1


= 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


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 <>  Thu, 18 Feb 2010 14:22:54 +0100

prefix (1.1.0-1) unstable; urgency=high

  * Fix Btree opclass for supporting sub-ranges

 -- D


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

It was downloaded from

Copyright Holders:

 Copyright (c) 2008 - Dimitri Fontaine <>


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

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

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

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

Results 1 - 1 of 1
Help - FTP Sites List - Software Dir.
Search over 15 billion files
© 1997-2017