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

From: itagaki(at)pgfoundry(dot)org (User Itagaki)
To: pgsql-committers(at)postgresql(dot)org
Subject: textsearch-ja - textsearch_senna: Support LIKE-compatible search with
Date: 2009-05-14 03:54:40
Message-ID: 20090514035440.F38DB17ADF05@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Browse pgsql-committers by date

  From Date Subject
Next Message User Itagaki 2009-05-14 06:58:11 reorg - pg_reorg: New Directory
Previous Message Tom Lane 2009-05-13 22:32:55 pgsql: Add checks to DefineQueryRewrite() to prohibit attaching rules to