postgresql-16-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 screenshot

Hint: 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-16-prefix