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

[ Source: prefix  ]

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

• dep: libc0.1 (>= 2.3.4) [kfreebsd-amd64, kfreebsd-i386]

  Embedded GNU C Library: Shared libraries
  also a virtual package provided by libc0.1-udeb

• dep: libc0.3 (>= 2.3.4) [hurd-i386]

  Embedded GNU C Library: Shared libraries
  also a virtual package provided by libc0.3-udeb

• dep: libc6 (>= 2.13) [s390x, sh4]

  Embedded GNU C Library: Shared libraries
  also a virtual package provided by libc6-udeb

  dep: libc6 (>= 2.13-28) [armhf]

  dep: libc6 (>= 2.3.4) [amd64, i386, mips, mipsel]

  dep: libc6 (>= 2.4) [armel, powerpc, powerpcspe, s390]

  dep: libc6 (>= 2.6) [sparc]

• dep: libc6.1 (>= 2.3.4) [ia64]

  Embedded GNU C Library: Shared libraries
  also a virtual package provided by libc6.1-udeb

  dep: libc6.1 (>= 2.4) [alpha]

• dep: postgresql-9.1

  object-relational SQL database, version 9.1 server

Download postgresql-9.1-prefix

Download for all available architectures

Architecture	Package Size	Installed Size	Files
alpha (unofficial port)	23.4 kB	128.0 kB	[list of files]
amd64	25.5 kB	119.0 kB	[list of files]
armel	22.5 kB	114.0 kB	[list of files]
armhf	20.5 kB	106.0 kB	[list of files]
hurd-i386	26.1 kB	122.0 kB	[list of files]
i386	26.1 kB	122.0 kB	[list of files]
ia64	28.3 kB	144.0 kB	[list of files]
kfreebsd-amd64	25.4 kB	73.0 kB	[list of files]
kfreebsd-i386	26.1 kB	77.0 kB	[list of files]
mips	21.7 kB	121.0 kB	[list of files]
mipsel	21.8 kB	121.0 kB	[list of files]
powerpc	22.6 kB	114.0 kB	[list of files]
powerpcspe (unofficial port)	23.5 kB	67.0 kB	[list of files]
s390	24.6 kB	122.0 kB	[list of files]
s390x	25.6 kB	127.0 kB	[list of files]
sh4 (unofficial port)	22.3 kB	114.0 kB	[list of files]
sparc	20.8 kB	118.0 kB	[list of files]