Re: pg_trgm - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_trgm
Date
Msg-id 14274.1274968540@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_trgm  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: pg_trgm
List pgsql-hackers
Tatsuo Ishii <ishii@postgresql.org> writes:
> What is your locale?
>> It was en_EN.UTF-8. Interesting. With C it fails...

> Yes, pg_trgm seems to have problems with multibyte + C locale.

It's not a problem, it's just pilot error, or possibly inadequate
documentation.  pg_trgm uses the locale's definition of "alpha",
"digit", etc.  In C locale only basic ASCII letters and digits will be
recognized as word constituents.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Exposing the Xact commit order to the user
Next
From: Greg Stark
Date:
Subject: Re: Exposing the Xact commit order to the user