Index for Levenshtein distance (better format)

From: "Janek Sendrowski" <janek12(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Index for Levenshtein distance (better format)
Date: 2013-07-21 14:46:00
Message-ID: trinity-b4f56b39-4ab2-4311-a321-89c3fc95f075-1374417959934@3capp-webde-bs04
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Im searching for a suitable Index for my query witch compares Strings with the Levenshtein distance.

I read that a prefix index would fit, but I dont know how to build it. I only know that its supported by Gist.

I couldn't find an instructions so I hope someone can help me.
 
Best regards,
Janek
 
 

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Moshe Jacobson 2013-07-21 19:41:51 Re: odd locking behaviour
Previous Message Mag Gam 2013-07-21 06:26:48 Re: Mag Gam