Skip site navigation (1)Skip section navigation (2) 
Date:      Wed, 26 Sep 2018 20:23:30 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 231748] [NEW PORT] databases/prefix: Prefix Range module for PostgreSQL
Message-ID:  <bug-231748-7788@https.bugs.freebsd.org/bugzilla/>
next in thread | raw e-mail | index | archive | help 
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D231748

            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@FreeBSD.org
          Reporter: lbartoletti@tuxfamily.org
 Attachment #197533 maintainer-approval+
             Flags:
             Flags: maintainer-feedback+

Created attachment 197533
  --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=3D197533&action=
=3Dedit
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;

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

Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-231748-7788>