[Bug 231748] [NEW PORT] databases/prefix: Prefix Range module for PostgreSQL

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=231748

            Bug ID: 231748
           Summary: [NEW PORT] databases/prefix: Prefix Range module for
                    PostgreSQL
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
               URL: https://github.com/dimitri/prefix
                OS: Any
            Status: New
          Keywords: easy, patch-ready
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs at FreeBSD.org
          Reporter: lbartoletti at tuxfamily.org
 Attachment #197533 maintainer-approval+
             Flags:
             Flags: maintainer-feedback+

Created attachment 197533
  --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=197533&action=edit
databases/prefix

This module is written by Dimitri Fontaine with a great amount of help from
RhodiumToad (formely known as AndrewSN), who was the one advising for a GiST
opclass to solve the prefix matching problem.

Prefix matching is both very common and important in telephony applications,
where call routing and costs depend on matching caller/callee phone number to
an operator prefix.

Let's say the prefixes table is called prefixes, a typical query will try to
match a phone number to the longest prefix in the table:

SELECT *
  FROM prefixes
 WHERE prefix @> '0123456789'
ORDER BY length(prefix) DESC LIMIT 1;

-- 
You are receiving this mail because:
You are the assignee for the bug.