all options
wheezy  ] [  jessie  ] [  sid  ] [  experimental  ]
[ Source: prefix  ]

Package: postgresql-9.1-prefix (1.2.0-1)

Links for postgresql-9.1-prefix

Screenshot

Debian Resources:

Download Source Package prefix:

Maintainer:

Similar packages:

Experimental package

Warning: This package is from the experimental distribution. That means it is likely unstable or buggy, and it may even cause data loss. Please be sure to consult the changelog and other possible documentation before using it.

Prefix Range module for PostgreSQL

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.

Other Packages Related to postgresql-9.1-prefix

  • depends
  • recommends
  • suggests

Download postgresql-9.1-prefix

Download for all available architectures
Architecture Package Size Installed Size Files
alpha (unofficial port) 23.4 kB128.0 kB [list of files]
amd64 25.5 kB119.0 kB [list of files]
armel 22.5 kB114.0 kB [list of files]
armhf 20.5 kB106.0 kB [list of files]
hurd-i386 26.1 kB122.0 kB [list of files]
i386 26.1 kB122.0 kB [list of files]
ia64 28.3 kB144.0 kB [list of files]
kfreebsd-amd64 25.4 kB73.0 kB [list of files]
kfreebsd-i386 26.1 kB77.0 kB [list of files]
mips 21.7 kB121.0 kB [list of files]
mipsel 21.8 kB121.0 kB [list of files]
powerpc 22.6 kB114.0 kB [list of files]
powerpcspe (unofficial port) 23.5 kB67.0 kB [list of files]
s390 24.6 kB122.0 kB [list of files]
s390x 25.6 kB127.0 kB [list of files]
sh4 (unofficial port) 22.3 kB114.0 kB [list of files]
sparc 20.8 kB118.0 kB [list of files]