Forum: First prefix release

Posted by: Dimitri Fontaine
Date: 2008-04-24 19:55
Summary:First prefix release
Project:prefix

The prefix project first release allows you to make fast (GiST indexed) lookups on the longest prefix in a table, for example:

SELECT * FROM prefixes WHERE prefix @> query;

The most common usage is with telephone numbers, though all text is supported by the prefix_range datatype.
This project has not yet categorized itself in the Trove Software Map