Binary package “postgresql-9.3-prefix” in ubuntu trusty
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.
Source package
Published versions
- postgresql-9.3-prefix 1.2.2-1 in amd64 (Proposed)
- postgresql-9.3-prefix 1.2.2-1 in amd64 (Release)
- postgresql-9.3-prefix 1.2.2-1 in arm64 (Proposed)
- postgresql-9.3-prefix 1.2.2-1 in arm64 (Release)
- postgresql-9.3-prefix 1.2.2-1 in armhf (Proposed)
- postgresql-9.3-prefix 1.2.2-1 in armhf (Release)
- postgresql-9.3-prefix 1.2.2-1 in i386 (Proposed)
- postgresql-9.3-prefix 1.2.2-1 in i386 (Release)
- postgresql-9.3-prefix 1.2.2-1 in powerpc (Proposed)
- postgresql-9.3-prefix 1.2.2-1 in powerpc (Release)
- postgresql-9.3-prefix 1.2.2-1 in ppc64el (Release)