Kouhei Sutou
null+****@clear*****
Thu Oct 29 17:12:23 JST 2015
Kouhei Sutou 2015-10-29 17:12:23 +0900 (Thu, 29 Oct 2015) New Revision: 8a79018e931159f29d9e7ec6b027c71d76003365 https://github.com/pgroonga/pgroonga.github.io/commit/8a79018e931159f29d9e7ec6b027c71d76003365 Message: Mention about ILIKE Modified files: _po/ja/tutorial/index.po ja/tutorial/index.md tutorial/index.md Modified: _po/ja/tutorial/index.po (+9 -2) =================================================================== --- _po/ja/tutorial/index.po 2015-10-29 17:08:00 +0900 (dbeaffe) +++ _po/ja/tutorial/index.po 2015-10-29 17:12:23 +0900 (a2b03e5) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2015-10-25 22:33+0900\n" +"PO-Revision-Date: 2015-10-29 17:11+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -166,7 +166,8 @@ msgstr "全文検索をする場合は次の演算子を使います。" msgid "" " * `%%`\n" " * `@@`\n" -" * `LIKE`" +" * `LIKE`\n" +" * `ILIKE`" msgstr "" msgid "#### `%%` operator" @@ -246,6 +247,9 @@ msgstr "" msgid "See [`@@` operator](../reference/operators/query.html) for more details." msgstr "詳細は[`@@`演算子](../reference/operators/query.html)を参照してください。" +msgid "{: #like}" +msgstr "" + msgid "#### `LIKE` operator" msgstr "#### `LIKE`演算子" @@ -260,6 +264,9 @@ msgstr "`column LIKE '%キーワードd%'`は`column %% 'キーワード'`と等 msgid "See [`LIKE` operator](../reference/operators/like.html) for more details." msgstr "詳細は[`LIKE`演算子](../reference/operators/like.html)を参照してください。" +msgid "You can also use `ILIKE` operator like `LIKE` operator." +msgstr "`LIKE`演算子のように`ILIKE`演算子を使うこともできます。" + msgid "{: #score}" msgstr "" Modified: ja/tutorial/index.md (+5 -0) =================================================================== --- ja/tutorial/index.md 2015-10-29 17:08:00 +0900 (edd6a56) +++ ja/tutorial/index.md 2015-10-29 17:12:23 +0900 (09d36e0) @@ -81,6 +81,7 @@ SET enable_seqscan = off; * `%%` * `@@` * `LIKE` + * `ILIKE` #### `%%`演算子 @@ -116,6 +117,8 @@ SELECT * FROM memos WHERE content @@ 'PGroonga OR PostgreSQL'; 詳細は[`@@`演算子](../reference/operators/query.html)を参照してください。 +{: #like} + #### `LIKE`演算子 PGroongaは`LIKE`演算子をサポートしています。既存のSQLを変更しなくてもPGroongaを使った高速な全文検索を実現できます。 @@ -133,6 +136,8 @@ SELECT * FROM memos WHERE content %% '全文検索'; 詳細は[`LIKE`演算子](../reference/operators/like.html)を参照してください。 +`LIKE`演算子のように`ILIKE`演算子を使うこともできます。 + {: #score} ### スコアー Modified: tutorial/index.md (+5 -0) =================================================================== --- tutorial/index.md 2015-10-29 17:08:00 +0900 (e3dcbf1) +++ tutorial/index.md 2015-10-29 17:12:23 +0900 (9653e6f) @@ -81,6 +81,7 @@ There are the following operators to perform full text search: * `%%` * `@@` * `LIKE` + * `ILIKE` #### `%%` operator @@ -115,6 +116,8 @@ See [Groonga document](http://groonga.org/docs/reference/grn_expr/query_syntax.h See [`@@` operator](../reference/operators/query.html) for more details. +{: #like} + #### `LIKE` operator PGroonga supports `LIKE` operator. You can perform fast full text search by PGroonga without changing existing SQL. @@ -131,6 +134,8 @@ SELECT * FROM memos WHERE content %% 'engine'; See [`LIKE` operator](../reference/operators/like.html) for more details. +You can also use `ILIKE` operator like `LIKE` operator. + {: #score} ### Score -------------- next part -------------- HTML����������������������������...Download