Re: [HACKERS] KEEPONLYALNUM for pg_trgm is not documented

2011-09-05 Thread Bruce Momjian
Robert Haas wrote: > On Fri, Mar 11, 2011 at 3:59 AM, Fujii Masao wrote: > > On Fri, Mar 11, 2011 at 5:52 PM, Itagaki Takahiro > > wrote: > >> contrib/pg_trgm in 9.1 becomes more attractive feature by index supports > >> for LIKE operators, but only alphabet and numeric characters are indexed > >

Re: [HACKERS] KEEPONLYALNUM for pg_trgm is not documented

2011-03-11 Thread Tom Lane
Itagaki Takahiro writes: > contrib/pg_trgm in 9.1 becomes more attractive feature by index supports > for LIKE operators, but only alphabet and numeric characters are indexed > by default. But, we can modify KEEPONLYALNUM in the source code to > keep all characters in n-gram words. > However, the

Re: [HACKERS] KEEPONLYALNUM for pg_trgm is not documented

2011-03-11 Thread Robert Haas
On Fri, Mar 11, 2011 at 3:59 AM, Fujii Masao wrote: > On Fri, Mar 11, 2011 at 5:52 PM, Itagaki Takahiro > wrote: >> contrib/pg_trgm in 9.1 becomes more attractive feature by index supports >> for LIKE operators, but only alphabet and numeric characters are indexed >> by default. But, we can modif

Re: [HACKERS] KEEPONLYALNUM for pg_trgm is not documented

2011-03-11 Thread Fujii Masao
On Fri, Mar 11, 2011 at 5:52 PM, Itagaki Takahiro wrote: > contrib/pg_trgm in 9.1 becomes more attractive feature by index supports > for LIKE operators, but only alphabet and numeric characters are indexed > by default. But, we can modify KEEPONLYALNUM in the source code to > keep all characters

[HACKERS] KEEPONLYALNUM for pg_trgm is not documented

2011-03-11 Thread Itagaki Takahiro
contrib/pg_trgm in 9.1 becomes more attractive feature by index supports for LIKE operators, but only alphabet and numeric characters are indexed by default. But, we can modify KEEPONLYALNUM in the source code to keep all characters in n-gram words. However, the limitation and KEEPONLYALNUM are no