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

Поиск
Список
Период
Сортировка
От itagaki@pgfoundry.org (User Itagaki)
Тема textsearch-ja - textsearch_senna: Support LIKE-compatible search with
Дата
Msg-id 20090514035440.F38DB17ADF05@pgfoundry.org
обсуждение исходный текст
Список pgsql-committers
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)
Дата:
Сообщение: pgsql: Add checks to DefineQueryRewrite() to prohibit attaching rules to
Следующее
От: itagaki@pgfoundry.org (User Itagaki)
Дата:
Сообщение: reorg - pg_reorg: New Directory