Re: contrib/levenshtein() has a bug? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: contrib/levenshtein() has a bug?
Date
Msg-id 20060928193707.GB16473@svana.org
Whole thread Raw
In response to contrib/levenshtein() has a bug?  (Ben <bench@silentmedia.com>)
List pgsql-general
On Thu, Sep 28, 2006 at 12:02:34PM -0700, Ben wrote:
> The levenshtein function from contrib/fuzzystrmatch.sql has a max arg
> length of 255. OK, that's cool. But check this out:
>
<snip>
> mbrainz_db=> select levenshtein(name,'foo') from public.track;
> ERROR:  argument exceeds max length: 255

The message is slightly wrong, the max length is actually one more. You
can adjust the maximum length by changing the params in
fuzzystrmatch.h and recompiling.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Ben
Date:
Subject: contrib/levenshtein() has a bug?
Next
From: Tom Lane
Date:
Subject: Re: contrib/levenshtein() has a bug?