Fujii Masao
masao****@gmail*****
2015年 8月 27日 (木) 02:01:21 JST
On Wed, Aug 26, 2015 at 11:02 PM, Masahiko Sawada <sawad****@gmail*****> wrote: > On Wed, Aug 26, 2015 at 7:31 PM, Fujii Masao <masao****@gmail*****> wrote: >> Hi, >> >> The pg_bigm document compares pg_bigm with pg_trgm from various angles. >> But I found that there is at least one missing angle to take into consideration >> when comparing them. That is the available text search operators. pg_bigm >> supports only LIKE operator, OTOH, pg_trgm supports not only LIKE but also >> ILIKE, ~ and ~* operators. I think that this information should be added into >> the document. Patch attached. Thought? >> > > I agree. > We also should include % (for pg_trgm) and =% (for pg_bigm) operators, right? I intentionally excluded it from the patch because (1) they are not *general* text search operators like LIKE, i.e., only pg_trgm and pg_bigm support them, (2) there is already the angle like "Similarity search" in the comparison table in the document. Thought? Regards, -- Fujii Masao
Fork