Port details on branch 2022Q3 |
- postgresql-prefix Prefix Range module for PostgreSQL
- 1.2.9 databases =0 1.2.9Version of this port present on the latest quarterly branch.
- Maintainer: lbartoletti@FreeBSD.org
- Port Added: 2018-12-14 19:39:56
- Last Update: 2023-04-15 13:14:58
- Commit Hash: a40c0e7
- License: PostgreSQL
- WWW:
- https://github.com/dimitri/prefix
- Description:
- 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;
- ¦ ¦ ¦ ¦
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- postgresql13-prefix>0:databases/postgresql-prefix
- To install the port:
- cd /usr/ports/databases/postgresql-prefix/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/postgresql-prefix
- pkg install postgresql13-prefix
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: postgresql13-prefix
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1563903139
SHA256 (dimitri-prefix-v1.2.9_GH0.tar.gz) = 38d30a08d0241a8bbb8e1eb8f0152b385051665a8e621c8899e7c5068f8b511e
SIZE (dimitri-prefix-v1.2.9_GH0.tar.gz) = 75147
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- gmake>=4.3 : devel/gmake
- postgres : databases/postgresql13-server
- Runtime dependencies:
-
- postgres : databases/postgresql13-server
- There are no ports dependent upon this port
Configuration Options:
- ===> The following configuration options are available for postgresql13-prefix-1.2.9:
DOCS=on: Build and/or install documentation
===> Use 'make config' to modify these settings
- Options name:
- databases_postgresql-prefix
- USES:
- gmake pgsql:11+
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|