Masahiko Sawada
sawad****@gmail*****
2015年 8月 27日 (木) 02:20:15 JST
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? Regards, -- Masahiko Sawada
Fork