Index: head/databases/postgresql-prefix/Makefile =================================================================== --- head/databases/postgresql-prefix/Makefile (revision 507513) +++ head/databases/postgresql-prefix/Makefile (revision 507514) @@ -1,29 +1,28 @@ # $FreeBSD$ PORTNAME= prefix -PORTVERSION= 1.2.8 -PORTREVISION= 1 +PORTVERSION= 1.2.9 DISTVERSIONPREFIX= v CATEGORIES= databases PKGNAMEPREFIX= postgresql${PGSQL_VER:S/.//}- MAINTAINER= lbartoletti@tuxfamily.org COMMENT= Prefix Range module for PostgreSQL LICENSE= PostgreSQL USES= gmake pgsql:9.1+ WANT_PGSQL= server USE_GITHUB= yes GH_ACCOUNT= dimitri OPTIONS_DEFINE= DOCS post-install: ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/prefix.so post-install-DOCS-on: @${MKDIR} ${STAGEDIR}${DOCSDIR} (cd ${WRKSRC} ; ${INSTALL_DATA} README.md TESTS.md ${STAGEDIR}${DOCSDIR}) .include Index: head/databases/postgresql-prefix/distinfo =================================================================== --- head/databases/postgresql-prefix/distinfo (revision 507513) +++ head/databases/postgresql-prefix/distinfo (revision 507514) @@ -1,3 +1,3 @@ -TIMESTAMP = 1537990947 -SHA256 (dimitri-prefix-v1.2.8_GH0.tar.gz) = db568a543cddfd5542e6e34c9ed804d842151667897b13657ca9954bf2fe115c -SIZE (dimitri-prefix-v1.2.8_GH0.tar.gz) = 74974 +TIMESTAMP = 1563903139 +SHA256 (dimitri-prefix-v1.2.9_GH0.tar.gz) = 38d30a08d0241a8bbb8e1eb8f0152b385051665a8e621c8899e7c5068f8b511e +SIZE (dimitri-prefix-v1.2.9_GH0.tar.gz) = 75147 Index: head/databases/postgresql-prefix/pkg-descr =================================================================== --- head/databases/postgresql-prefix/pkg-descr (revision 507513) +++ head/databases/postgresql-prefix/pkg-descr (revision 507514) @@ -1,13 +1,13 @@ Prefix matching is both very common and important in telephony applications, -where call routing and costs depend on matching caller/callee phone number +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 * +SELECT * FROM prefixes WHERE prefix @> '0123456789' ORDER BY length(prefix) DESC LIMIT 1; WWW: https://github.com/dimitri/prefix