Re: BUG #7867: Similarity function fails

Lists: pgsql-bugs
From: michele(dot)baravalle(at)me(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7867: Similarity function fails
Date: 2013-02-11 16:09:44
Message-ID: E1U4vwu-0003NT-4A@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7867
Logged by: Michele Baravalle
Email address: michele(dot)baravalle(at)me(dot)com
PostgreSQL version: 9.2.3
Operating system: Mac OSX 10.8
Description:

Using this sql:

SELECT similarity('Круиз-контроль отключен', 'Круиз-контроль отключен');

work well on Linux and Windows and the result is 1: on OSX the result is
NaN.

Thanks


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: michele(dot)baravalle(at)me(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7867: Similarity function fails
Date: 2013-02-12 00:44:51
Message-ID: 3103.1360629891@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

michele(dot)baravalle(at)me(dot)com writes:
> Using this sql:

> SELECT similarity('- ', '- ');

> work well on Linux and Windows and the result is 1: on OSX the result is
> NaN.

I couldn't reproduce that on my own Mac. I tried it in ru_RU.UTF-8 and
en_US.UTF-8 locales --- perhaps you are using something else?

regards, tom lane