Обсуждение: textsearch-ja - textsearch_senna: Support LIKE-compatible search with
textsearch-ja - textsearch_senna: Support LIKE-compatible search with
От
itagaki@pgfoundry.org (User Itagaki)
Дата:
Log Message: ----------- Support LIKE-compatible search with like_ops operator class. Usage is: CREATE INDEX idx_like ON tbl USING senna (t like_ops); SELECT * FROM tbl WHERE t LIKE '%foo%'; -- it can use index! We can use LIKE (~~) operator for 8.4 and ~~% operator for all versions. LIKE operators cannot be supported for 8.3 or earlier versions because of postgres' limitation. Modified Files: -------------- textsearch_senna: textsearch_senna-8.2.sql.in (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/textsearch-ja/textsearch_senna/textsearch_senna-8.2.sql.in.diff?r1=1.2&r2=1.3) textsearch_senna-8.3.sql.in (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/textsearch-ja/textsearch_senna/textsearch_senna-8.3.sql.in.diff?r1=1.2&r2=1.3) textsearch_senna-8.4.sql.in (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/textsearch-ja/textsearch_senna/textsearch_senna-8.4.sql.in.diff?r1=1.2&r2=1.3) textsearch_senna.c (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/textsearch-ja/textsearch_senna/textsearch_senna.c.diff?r1=1.5&r2=1.6) uninstall_textsearch_senna.sql (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/textsearch-ja/textsearch_senna/uninstall_textsearch_senna.sql.diff?r1=1.3&r2=1.4) textsearch_senna/expected: textsearch_senna.out (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/textsearch-ja/textsearch_senna/expected/textsearch_senna.out.diff?r1=1.3&r2=1.4) textsearch_senna/sql: textsearch_senna.sql (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/textsearch-ja/textsearch_senna/sql/textsearch_senna.sql.diff?r1=1.3&r2=1.4)