Ah, yes, you are correct.
Hm, it's too bad levenshtein() is ascii-only.
On Thu, 28 Sep 2006, Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
The levenshtein function from contrib/fuzzystrmatch.sql has a max arg
length of 255. OK, that's cool. But check this out:
mbrainz_db=> select max(length(name)) from public.track;
max
-----
255
(1 row)
mbrainz_db=> select levenshtein(name,'foo') from public.track;
ERROR: argument exceeds max length: 255
That seems odd.
length() measures in characters whereas the limit in question is being
enforced in bytes. You got any multibyte characters in there?
(It looks to me like levenshtein() is utterly non-multibyte-aware,
which is probably a bug in itself.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
