Re: [HACKERS] strange behavior of pg_trgm's similarity function

2013-10-10 Thread Fujii Masao
On Thu, Oct 10, 2013 at 11:00 PM, Merlin Moncure wrote: > On Thu, Oct 10, 2013 at 7:12 AM, Heikki Linnakangas > wrote: >> On 10.10.2013 15:03, Fujii Masao wrote: >>> >>> Hi, >>> >>> The behavior of pg_trgm's similarity function seems strange. Is this >>> intentional? >>> >>> I was thinking that t

Re: [HACKERS] strange behavior of pg_trgm's similarity function

2013-10-10 Thread Merlin Moncure
On Thu, Oct 10, 2013 at 7:12 AM, Heikki Linnakangas wrote: > On 10.10.2013 15:03, Fujii Masao wrote: >> >> Hi, >> >> The behavior of pg_trgm's similarity function seems strange. Is this >> intentional? >> >> I was thinking that the following three calls of the similarity function >> return >> the

Re: [HACKERS] strange behavior of pg_trgm's similarity function

2013-10-10 Thread Heikki Linnakangas
On 10.10.2013 15:03, Fujii Masao wrote: Hi, The behavior of pg_trgm's similarity function seems strange. Is this intentional? I was thinking that the following three calls of the similarity function return the same number because the second argument is just the three characters contained in the