postgresql-9.3-prefix binary package in Ubuntu Trusty i386
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.
Publishing history
Date | Status | Target | Component | Section | Priority | Phased updates | Version | ||
---|---|---|---|---|---|---|---|---|---|
2014-01-27 19:18:22 UTC | Published | Ubuntu Trusty i386 | release | universe | database | Extra | 1.2.2-1 | ||
|
|||||||||
Deleted | Ubuntu Trusty i386 | proposed | universe | database | Extra | 1.2.2-1 | |||
|
|||||||||
2014-01-27 19:19:38 UTC | Superseded | Ubuntu Trusty i386 | release | universe | database | Extra | 1.2.1-1 | ||
|
|||||||||
2014-01-29 00:10:10 UTC | Deleted | Ubuntu Trusty i386 | proposed | universe | database | Extra | 1.2.1-1 | ||
|