notbugIf you buy from Amazon USA, please support us by using this link.
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
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 : PortsMon
    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 line: 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, SuperNews, 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
powerdnsMar 19
rubygem-actionview4Mar 18
rubygem-actionview5Mar 18
rubygem-actionview50Mar 18
puttyMar 17
putty-gtk2Mar 17
putty-nogtkMar 17
py-notebookMar 16
ruby-gemsMar 15
ntpMar 07
openssl*Mar 07
openssl111Mar 07
rsshMar 06
rt42Mar 06
rt44Mar 06

13 vulnerabilities affecting 42 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-03-19 14:51:44


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 36287
Broken 116
Deprecated 119
Ignore 337
Forbidden 5
Restricted 161
No CDROM 74
Vulnerable 37
Expired 6
Set to expire 93
Interactive 0
new 24 hours 5
new 48 hours7
new 7 days36
new fortnight65
new month139

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