Re: Fuzzy substring searching with the pg_trgm extension

From: Artur Zakirov <a(dot)zakirov(at)postgrespro(dot)ru>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fuzzy substring searching with the pg_trgm extension
Date: 2016-02-02 12:45:09
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 01.02.2016 20:12, Artur Zakirov wrote:
> I have changed the patch:
> 1 - was corrected, duplicates were deleted.
> 2 - I have added operators <<-> and <->> with GiST index supporting. A
> regression test will pass only with the patch
> 3 - the function substring_similarity() was renamed to
> subword_similarity().
> But there is not a function substring_similarity_pos() yet. It is not
> trivial.

Sorry, in the previous patch was a typo. Here is the fixed patch.

Artur Zakirov
Postgres Professional:
Russian Postgres Company

Attachment Content-Type Size
pg_trgm_guc_v2.patch text/x-patch 8.8 KB
pg_trgm_subword_v6.patch text/x-patch 112.4 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Anastasia Lubennikova 2016-02-02 12:50:34 Re: WIP: Covering + unique indexes.
Previous Message Alvaro Herrera 2016-02-02 12:35:35 Re: Add links to commit fests to patch summary page