Kouhei Sutou
null+****@clear*****
Sun Oct 25 22:15:51 JST 2015
Kouhei Sutou 2015-10-25 22:15:51 +0900 (Sun, 25 Oct 2015) New Revision: 0e2216455c3345ad460b69cfdc806f1e20b59d29 https://github.com/pgroonga/pgroonga.github.io/commit/0e2216455c3345ad460b69cfdc806f1e20b59d29 Message: Use common format Modified files: _po/ja/reference/operators/match.po ja/reference/operators/match.md reference/operators/match.md Modified: _po/ja/reference/operators/match.po (+82 -6) =================================================================== --- _po/ja/reference/operators/match.po 2015-10-25 22:11:09 +0900 (9527d3e) +++ _po/ja/reference/operators/match.po 2015-10-25 22:15:51 +0900 (062f668) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2015-10-24 17:48+0900\n" +"PO-Revision-Date: 2015-10-25 22:15+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -22,20 +22,96 @@ msgstr "" msgid "# `%%` operator" msgstr "# `%%`演算子" -msgid "You can do full text search with one keyword by `%%` operator:" +msgid "## Summary" +msgstr "## 概要" + +msgid "`%%` operator performs full text search by one keyword." +msgstr "`%%`は1つのキーワードで全文検索を実行します。" + +msgid "## Syntax" +msgstr "## 構文" + +msgid "" +"```sql\n" +"column %% keyword\n" +"```" +msgstr "" + +msgid "`column` is a column to be searched." +msgstr "`column`は検索対象のカラムです。" + +msgid "`keyword` is a keyword for full text search. It's `text` type." +msgstr "`keyword`は全文検索で使うキーワードです。`text`型です。" + +msgid "## Usage" +msgstr "## 使い方" + +msgid "Here are sample schema and data for examples:" +msgstr "例に使うサンプルスキーマとデータは次の通りです。" + +msgid "" +"```sql\n" +"CREATE TABLE memos (\n" +" id integer,\n" +" content text\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content);\n" +"```" +msgstr "" + +msgid "" +"```sql\n" +"INSERT INTO memos VALUES (1, 'PostgreSQL is a relational database management s" +"ystem.');\n" +"INSERT INTO memos VALUES (2, 'Groonga is a fast full text search engine that s" +"upports all languages.');\n" +"INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Gro" +"onga as index.');\n" +"INSERT INTO memos VALUES (4, 'There is groonga command.');\n" +"```" +msgstr "" +"```sql\n" +"INSERT INTO memos VALUES (1, 'PostgreSQLはリレーショナル・データベース管理システムです。');\n" +"INSERT INTO memos VALUES (2, 'Groongaは日本語対応の高速な全文検索エンジンです。');\n" +"INSERT INTO memos VALUES (3, 'PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です" +"。');\n" +"INSERT INTO memos VALUES (4, 'groongaコマンドがあります。');\n" +"```" + +msgid "You can perform full text search with one keyword by `%%` operator:" msgstr "`%%`演算子を使うと1つキーワードで全文検索できます。" msgid "" "```sql\n" +"SELECT * FROM memos WHERE content %% 'engine';\n" +"-- id | content " +" \n" +"-- ----+----------------------------------------------------------------------" +"--\n" +"-- 2 | Groonga is a fast full text search engine that supports all languages" +".\n" +"-- (1 row)\n" +"```" +msgstr "" +"```sql\n" "SELECT * FROM memos WHERE content %% '全文検索';\n" +"\n" "-- id | content\n" "-- ----+---------------------------------------------------\n" "-- 2 | Groongaは日本語対応の高速な全文検索エンジンです。\n" -"-- (1 行)\n" +"-- (1 row)\n" "```" -msgstr "" msgid "" -"If you want to do full text search with multiple keywords or AND/OR search, us" -"e [`@@` operator](query.html)." +"If you want to perform full text search with multiple keywords or AND/OR searc" +"h, use [`@@` operator](query.html)." msgstr "複数のキーワードで検索したいときやAND/ORを使った検索をしたいときは[`@@`演算子](query.html)を使います。" + +msgid "## See also" +msgstr "## 参考" + +msgid " * [`@@` operator](query.html)" +msgstr " * [`@@`演算子](query.html)" Modified: ja/reference/operators/match.md (+40 -1) =================================================================== --- ja/reference/operators/match.md 2015-10-25 22:11:09 +0900 (d182b22) +++ ja/reference/operators/match.md 2015-10-25 22:15:51 +0900 (2d59bbb) @@ -5,14 +5,53 @@ layout: ja # `%%`演算子 +## 概要 + +`%%`は1つのキーワードで全文検索を実行します。 + +## 構文 + +```sql +column %% keyword +``` + +`column`は検索対象のカラムです。 + +`keyword`は全文検索で使うキーワードです。`text`型です。 + +## 使い方 + +例に使うサンプルスキーマとデータは次の通りです。 + +```sql +CREATE TABLE memos ( + id integer, + content text +); + +CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content); +``` + +```sql +INSERT INTO memos VALUES (1, 'PostgreSQLはリレーショナル・データベース管理システムです。'); +INSERT INTO memos VALUES (2, 'Groongaは日本語対応の高速な全文検索エンジンです。'); +INSERT INTO memos VALUES (3, 'PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。'); +INSERT INTO memos VALUES (4, 'groongaコマンドがあります。'); +``` + `%%`演算子を使うと1つキーワードで全文検索できます。 ```sql SELECT * FROM memos WHERE content %% '全文検索'; + -- id | content -- ----+--------------------------------------------------- -- 2 | Groongaは日本語対応の高速な全文検索エンジンです。 --- (1 行) +-- (1 row) ``` 複数のキーワードで検索したいときやAND/ORを使った検索をしたいときは[`@@`演算子](query.html)を使います。 + +## 参考 + + * [`@@`演算子](query.html) Modified: reference/operators/match.md (+45 -7) =================================================================== --- reference/operators/match.md 2015-10-25 22:11:09 +0900 (50fbf02) +++ reference/operators/match.md 2015-10-25 22:15:51 +0900 (b9c3047) @@ -5,14 +5,52 @@ layout: en # `%%` operator -You can do full text search with one keyword by `%%` operator: +## Summary + +`%%` operator performs full text search by one keyword. + +## Syntax + +```sql +column %% keyword +``` + +`column` is a column to be searched. + +`keyword` is a keyword for full text search. It's `text` type. + +## Usage + +Here are sample schema and data for examples: ```sql -SELECT * FROM memos WHERE content %% '全文検索'; --- id | content --- ----+--------------------------------------------------- --- 2 | Groongaは日本語対応の高速な全文検索エンジンです。 --- (1 行) +CREATE TABLE memos ( + id integer, + content text +); + +CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content); ``` -If you want to do full text search with multiple keywords or AND/OR search, use [`@@` operator](query.html). +```sql +INSERT INTO memos VALUES (1, 'PostgreSQL is a relational database management system.'); +INSERT INTO memos VALUES (2, 'Groonga is a fast full text search engine that supports all languages.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga as index.'); +INSERT INTO memos VALUES (4, 'There is groonga command.'); +``` + +You can perform full text search with one keyword by `%%` operator: + +```sql +SELECT * FROM memos WHERE content %% 'engine'; +-- id | content +-- ----+------------------------------------------------------------------------ +-- 2 | Groonga is a fast full text search engine that supports all languages. +-- (1 row) +``` + +If you want to perform full text search with multiple keywords or AND/OR search, use [`@@` operator](query.html). + +## See also + + * [`@@` operator](query.html) -------------- next part -------------- HTML����������������������������...Download