notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Port details
postgresql-prefix Prefix Range module for PostgreSQL
1.2.8 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port
1.2.8Version of this port present on the latest quarterly branch.
Maintainer: lbartoletti@tuxfamily.org search for ports maintained by this maintainer
Port Added: 2018-12-14 19:39:56
Last Update: 2018-12-14 19:39:39
SVN Revision: 487459
License: PostgreSQL
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;

WWW: https://github.com/dimitri/prefix
SVNWeb : Homepage
    Pseudo-pkg-plist information, but much better, from make generate-plist
    Expand this list (10 items)
  1. /usr/local/share/licenses/postgresql95-prefix-1.2.8/catalog.mk
  2. /usr/local/share/licenses/postgresql95-prefix-1.2.8/LICENSE
  3. /usr/local/share/licenses/postgresql95-prefix-1.2.8/PostgreSQL
  4. lib/postgresql/prefix.so
  5. share/doc/prefix/README.md
  6. share/doc/prefix/TESTS.md
  7. share/postgresql/extension/prefix--1.1--1.2.0.sql
  8. share/postgresql/extension/prefix--1.2.0.sql
  9. share/postgresql/extension/prefix--unpackaged--1.2.0.sql
  10. share/postgresql/extension/prefix.control
  11. Collapse this list.
Dependency lines:
  • postgresql95-prefix>0:databases/postgresql-prefix

To install the port: cd /usr/ports/databases/postgresql-prefix/ && make install clean
To add the package: pkg install postgresql95-prefix

PKGNAME: postgresql95-prefix

There is no flavor information for this port.

distinfo:

TIMESTAMP = 1537990947
SHA256 (dimitri-prefix-v1.2.8_GH0.tar.gz) = db568a543cddfd5542e6e34c9ed804d842151667897b13657ca9954bf2fe115c
SIZE (dimitri-prefix-v1.2.8_GH0.tar.gz) = 74974


NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:
  1. gmake : devel/gmake
  2. postgres : databases/postgresql95-server
Runtime dependencies:
  1. postgres : databases/postgresql95-server
There are no ports dependent upon this port

Configuration Options
===> The following configuration options are available for postgresql95-prefix-1.2.8:
     DOCS=on: Build and/or install documentation
===> Use 'make config' to modify these settings

USES:
gmake pgsql:9.1+

Master Sites:
  1. https://codeload.github.com/dimitri/prefix/tar.gz/v1.2.8?dummy=/

Number of commits found: 1

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
14 Dec 2018 19:39:39
Original commit files touched by this commit  1.2.8
Revision:487459
dbn search for other commits by this committer
databases/portsgresql-prefix: Prefix Range module for PostgreSQL

Number of commits found: 1

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
ImageMagick6*Jun 17
ImageMagick6-nox11*Jun 17
ImageMagick7*Jun 17
ImageMagick7-nox11*Jun 17
GraphicsMagickJun 16
netatalk3Jun 16
chromiumJun 15
neovimJun 13
phpmyadminJun 13
vimJun 13
vim-consoleJun 13
vim-tinyJun 13
mybbJun 12
linux-flashplayerJun 11
drupal7Jun 08

12 vulnerabilities affecting 80 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-06-17 06:25:27


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 36700
Broken 82
Deprecated 120
Ignore 304
Forbidden 3
Restricted 162
No CDROM 74
Vulnerable 33
Expired 14
Set to expire 91
Interactive 0
new 24 hours 4
new 48 hours13
new 7 days34
new fortnight67
new month189

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2019 Dan Langille. All rights reserved.