Date: Sun, 28 Jul 2019 16:13:28 +0000 (UTC) From: Kai Knoblich <kai@FreeBSD.org> To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r507514 - head/databases/postgresql-prefix Message-ID: <201907281613.x6SGDS3P086214@repo.freebsd.org>
next in thread | raw e-mail | index | archive | help
Author: kai Date: Sun Jul 28 16:13:28 2019 New Revision: 507514 URL: https://svnweb.freebsd.org/changeset/ports/507514 Log: databases/postgresql-prefix: Update to 1.2.9 * Pet portlint by fixing whitespace issues in pkg-plist while I'm here. Changelog: * Add support for PostgreSQL 12 PR: 239452 Submitted by: lbartoletti <lbartoletti@tuxfamily.org> (maintainer) Modified: head/databases/postgresql-prefix/Makefile head/databases/postgresql-prefix/distinfo head/databases/postgresql-prefix/pkg-descr Modified: head/databases/postgresql-prefix/Makefile ============================================================================== --- head/databases/postgresql-prefix/Makefile Sun Jul 28 16:06:01 2019 (r507513) +++ head/databases/postgresql-prefix/Makefile Sun Jul 28 16:13:28 2019 (r507514) @@ -1,8 +1,7 @@ # $FreeBSD$ PORTNAME= prefix -PORTVERSION= 1.2.8 -PORTREVISION= 1 +PORTVERSION= 1.2.9 DISTVERSIONPREFIX= v CATEGORIES= databases PKGNAMEPREFIX= postgresql${PGSQL_VER:S/.//}- Modified: head/databases/postgresql-prefix/distinfo ============================================================================== --- head/databases/postgresql-prefix/distinfo Sun Jul 28 16:06:01 2019 (r507513) +++ head/databases/postgresql-prefix/distinfo Sun Jul 28 16:13:28 2019 (r507514) @@ -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 Modified: head/databases/postgresql-prefix/pkg-descr ============================================================================== --- head/databases/postgresql-prefix/pkg-descr Sun Jul 28 16:06:01 2019 (r507513) +++ head/databases/postgresql-prefix/pkg-descr Sun Jul 28 16:13:28 2019 (r507514) @@ -1,11 +1,11 @@ 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;
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201907281613.x6SGDS3P086214>