Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id CAA8F8B63D8
	for <pgsql-sql@postgresql.org>; Wed, 20 Jun 2012 13:30:54 -0300 (ADT)
Received: from mailout-de.gmx.net ([213.165.64.23])
	by makus.postgresql.org with smtp (Exim 4.72)
	(envelope-from <maps.on@gmx.net>) id 1ShNnx-0006Uv-QE
	for pgsql-sql@postgresql.org; Wed, 20 Jun 2012 16:30:54 +0000
Received: (qmail invoked by alias); 20 Jun 2012 16:30:40 -0000
Received: from mue-88-130-35-129.dsl.tropolys.de (EHLO [192.168.1.113])
	[88.130.35.129]
	by mail.gmx.net (mp033) with SMTP; 20 Jun 2012 18:30:40 +0200
X-Authenticated: #14269776
X-Provags-ID: V01U2FsdGVkX1/T5Z4bT6bTfU8OsW2zTh5d5cIQ/O7GGdclF3533P
	xMPV8bklKzeF7v
Message-ID: <4FE1FAAF.3090004@gmx.net>
Date: Wed, 20 Jun 2012 18:30:39 +0200
From: Andreas <maps.on@gmx.net>
User-Agent: Mozilla/5.0 (Windows NT 5.1;
	rv:13.0) Gecko/20120614 Thunderbird/13.0.1
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Is there a similarity-function that minds national charsets?
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Y-GMX-Trusted: 0
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201206/59
X-Sequence-Number: 36713

Hi,

Is there a similarity-function that minds national charsets?

Over here we've got some special cases that screw up the results on 
similarity().

Our characters: ä, ö, ü, ß
could as well be written as:  ae, oe, ue, ss

e.g.

select similarity ( 'Müller', 'Mueller' )
results to:  0.363636

In normal cases everything below 0.5 would be to far apart to be 
considered a match.

As it is, I had to transfer the contents of the table into a temporary 
table where I translate every ambigous char to it's 2 char representation.

Is there a solution so that detour is not necessary?