Fujii Masao
masao****@gmail*****
2015年 8月 27日 (木) 02:27:30 JST
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? Regards, -- Fujii Masao -------------- next part -------------- $B%F%-%9%H7A<00J30$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B... $B%U%!%$%kL>(B: available_text_search_operators_compare_with_pg_trgm_v2.patch $B7?(B: application/octet-stream $B%5%$%:(B: 1112 $B%P%$%H(B $B ＠ bL@(B: $BL5$7(BDownload
Fork