Paketname | postgresql-8.4-prefix |
Beschreibung | Prefix Range module for PostgreSQL |
Archiv/Repository | Offizielles Ubuntu Archiv lucid (universe) |
Version | 1.1.0-1.1 |
Sektion | universe/database |
Priorität | extra |
Installierte Größe | 108 Byte |
Hängt ab von | libc6 (>= 2.3.4), postgresql-8.4 |
Empfohlene Pakete | |
Paketbetreuer | Ubuntu Developers |
Quelle | prefix |
Paketgröße | 19412 Byte |
Prüfsumme MD5 | 095b213d5505282676520db1048a9a40 |
Prüfsumme SHA1 | 850613a01f5e8c1b752d38dcdd9570f96a27977a |
Prüfsumme SHA256 | bc36fc34d98630ebd7fa83802fdb58aa520c406ca6bc97ebbfb14d2f6ed84cd5 |
Link zum Herunterladen | postgresql-8.4-prefix_1.1.0-1.1_i386.deb |
Ausführliche Beschreibung | 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.
|