Bug 220428 - [NEW PORT] databases/pg_similarity: Set of functions and operators for executing similarity queries
Summary: [NEW PORT] databases/pg_similarity: Set of functions and operators for execut...
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Only Me
Assignee: Martin Wilke
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-07-02 06:34 UTC by Jov
Modified: 2018-07-28 14:58 UTC (History)
3 users (show)

See Also:


Attachments
pg_similarity.shar (2.98 KB, text/plain)
2017-07-02 06:34 UTC, Jov
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jov 2017-07-02 06:34:49 UTC
Created attachment 184004 [details]
pg_similarity.shar

Pg_similarity is an extension to support similarity queries on PostgreSQL. The
implementation is tightly integrated in the RDBMS in the sense that it defines
operators so instead of the traditional operators (= and <>) you can use ~~~
and ! (any of these operators represents a similarity function).

pg_similarity has three main components:

* Functions: a set of functions that implements similarity algorithms available
  in the literature. These functions can be used as UDFs and, will be the base
  for implementing the similarity operators;
* Operators: a set of operators defined at the top of similarity functions. They
  use similarity functions to obtain the similarity threshold and, compare its
  value to a user-defined threshold to decide if it is a match or not;
* Session Variables: a set of variables that store similarity function
  parameters. Theses variables can be defined at run time.

WWW: http://pgsimilarity.projects.pgfoundry.org

QA:
portlint -AC
looks fine.

poudriere testport passed on 11.0R-amd64
Comment 1 commit-hook freebsd_committer 2018-07-28 14:58:26 UTC
A commit references this bug:

Author: miwi
Date: Sat Jul 28 14:57:53 UTC 2018
New revision: 475583
URL: https://svnweb.freebsd.org/changeset/ports/475583

Log:
  pg_similarity is an extension to support similarity queries on PostgreSQL. The
  implementation is tightly integrated in the RDBMS in the sense that it defines
  operators so instead of the traditional operators (= and <>) you can use ~~~
  and ! (any of these operators represents a similarity function).

  pg_similarity has three main components:

  * Functions: a set of functions that implements similarity algorithms available
    in the literature. These functions can be used as UDFs and, will be the base
    for implementing the similarity operators;
  * Operators: a set of operators defined at the top of similarity functions. They
    use similarity functions to obtain the similarity threshold and, compare its
    value to a user-defined threshold to decide if it is a match or not;
  * Session Variables: a set of variables that store similarity function
    parameters. Theses variables can be defined at run time.

  WWW: http://pgsimilarity.projects.pgfoundry.org

  PR:		220428
  Submitted by:	Jov <amutu@amutu.com>
  Sponsored by:	iXsystems Inc.

Changes:
  head/databases/Makefile
  head/databases/pg_similarity/
  head/databases/pg_similarity/Makefile
  head/databases/pg_similarity/distinfo
  head/databases/pg_similarity/pkg-descr