- postgresql-15
- postgresql-15-jit-llvm (>= 14)
- libc6 (>= 2.14)
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.
Installed Size: 124.9 kB
Architectures: amd64 arm64