Welcome to the textsearch-ja Project Home Page


Integrated Full-Text-Search for Japanese language using morphological analyze.

The textsearch-ja project is a PostgreSQL Community project that is a part of the pgFoundry.

The pgFoundry page for the project is at http://pgfoundry.org/projects/textsearch-ja, where you can find downloads, documentation, bug reports, mailing lists, and a whole lot more.

日本語のページはこちら。

Text search functions

(These functions are only useful for Japanese users...)

Other search functions

Web search compatible query (web_query)

textsearch uses &, | and ! for AND, OR and NOT operators to control queries. They are different compared with general web search queries. The function web_query() convert space ' ', OR and hyphen '-' into tsquery operators.

=# SELECT to_tsquery('english', 'Relational Database');
ERROR:  syntax error in tsquery: "Relational Database"

=# SELECT to_tsquery('english', web_query('Relational Database'));
     to_tsquery
---------------------
 'relat' & 'databas'
(1 row)

NOTICE: Presently, OR operator has higher priority than AND operator. OR operator often has higher priority in general web searning.

Japanese analyzing functions

(These functions are only useful for Japanese users...)