Re: pg_trgm

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: peter_e(at)gmx(dot)net
Cc: ishii(at)postgresql(dot)org, ishii(at)sraoss(dot)co(dot)jp, tgl(at)sss(dot)pgh(dot)pa(dot)us, andres(at)anarazel(dot)de, pgsql-hackers(at)postgresql(dot)org, teodor(at)sigaev(dot)ru
Subject: Re: pg_trgm
Date: 2010-05-30 02:05:50
Message-ID: 20100530.110550.56358097.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > Wait. This works fine for me with stock pg_trgm. local is C and
> > encoding is UTF8. What version of PostgreSQL are you using? Mine is
> > 8.4.4.
>
> This is in 9.0, because 8.4 doesn't recognize the \u escape syntax. If
> you run this in 8.4, you're just comparing a sequence of ASCII letters
> and digits.

Hum. Still I prefer 8.4's behavior since anything is better than
returning NaN. It seems 9.0 does not have any escape route for
multibyte+C locale users.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

In response to

  • Re: pg_trgm at 2010-05-28 06:21:09 from Peter Eisentraut

Responses

  • Re: pg_trgm at 2010-05-30 11:36:57 from Peter Eisentraut

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2010-05-30 02:23:46 Re: Specification for Trusted PLs?
Previous Message Tatsuo Ishii 2010-05-30 01:53:14 Re: pg_trgm