textsearch-ja - textsearch_senna: Support LIKE-compatible search with

Поиск
Список
Период
Сортировка
Искать
От
itagaki@pgfoundry.org (User Itagaki)
Тема
textsearch-ja - textsearch_senna: Support LIKE-compatible search with
Дата
в 00:54:43
Msg-id
20090514035440.F38DB17ADF05@pgfoundry.org
Список
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)
В списке pgsql-committers по дате отправления
От: tgl@postgresql.org (Tom Lane)
Дата:
От: itagaki@pgfoundry.org (User Itagaki)
Дата:
FAQ