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)
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 |