Paketname | postgresql-8.4-prefix |
Beschreibung | Prefix Range module for PostgreSQL |
Archiv/Repository | Offizielles Debian Archiv squeeze (main) |
Version | 1.1.0-1.1 |
Sektion | database |
Priorität | extra |
Installierte Größe | 104 Byte |
Hängt ab von | libc6 (>= 2.1.3), postgresql-8.4 |
Empfohlene Pakete | |
Paketbetreuer | Dimitri Fontaine |
Quelle | prefix |
Paketgröße | 19226 Byte |
Prüfsumme MD5 | a5a948373d4154c95cce2471088666fd |
Prüfsumme SHA1 | 4091da9b98dfd1a877d72bf5cc9ca467393c851c |
Prüfsumme SHA256 | 9bd3947df571361bf4c6f678c11490568c565207177fb419956ad9fc2861de53 |
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.
|