| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
| Cc: | 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 11:36:57 |
| Message-ID: | 1275219417.12068.57.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On sön, 2010-05-30 at 11:05 +0900, Tatsuo Ishii wrote:
> > > 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.
I think you are confusing some things here. The \u escape syntax is for
string literals in general. The behavior of pg_trgm is still the same
in 8.4 and in 9.0. It's just easier in 9.0 to write out examples
relevant to the current problem.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2010-05-30 11:57:52 | Re: Is there anyway to get list of table name, before raw parser is analyze? |
| Previous Message | Peter Eisentraut | 2010-05-30 11:00:03 | server authentication over Unix-domain sockets |