postgresql-17-prefix

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:

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-17-prefix