Masahiko Sawada
sawad****@gmail*****
2015年 8月 27日 (木) 02:32:07 JST
On Thu, Aug 27, 2015 at 2:27 AM, Fujii Masao <masao****@gmail*****> wrote: > On Thu, Aug 27, 2015 at 2:20 AM, Masahiko Sawada <sawad****@gmail*****> wrote: >> On Thu, Aug 27, 2015 at 2:01 AM, Fujii Masao <masao****@gmail*****> wrote: >>> 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? >> >> I understood and agree with you. >> >> One more point; do we need to also write ~~ and ~~* operators along >> with LIKE and ILIKE? > > Okay, so what about the attached patch? > Thank you for the patch! Looks great. Regards, -- Masahiko Sawada
Fork