postgresql-14-prefix
Prefix Range module for PostgreSQL
Description
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.Upload more screenshots
Please help extend the collection of screenshots. Just make a screenshot and upload it here. You don't need to register or anything.
Upload a screenshotHint: upload an image here from your clipboard with Ctrl-V
Install this software package
If the package is available for the distribution you are currently using on your computer then install the software by clicking on…
Install postgresql-14-prefix