Kouhei Sutou
null+****@clear*****
Mon Aug 14 23:51:35 JST 2017
Kouhei Sutou 2017-08-14 23:51:35 +0900 (Mon, 14 Aug 2017) New Revision: 552238ec4b1e02d83c6fee4fe614d8955103db9f https://github.com/pgroonga/pgroonga.github.io/commit/552238ec4b1e02d83c6fee4fe614d8955103db9f Message: Use &@* for similar search Modified files: _po/ja/reference/operators/similar-search-v2.po ja/reference/index.md ja/reference/operators/similar-search-v2.md reference/operators/similar-search-v2.md Modified: _po/ja/reference/operators/similar-search-v2.po (+19 -16) =================================================================== --- _po/ja/reference/operators/similar-search-v2.po 2017-08-14 23:09:02 +0900 (ceb9543) +++ _po/ja/reference/operators/similar-search-v2.po 2017-08-14 23:51:35 +0900 (117cba3) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2017-07-20 15:41+0900\n" +"PO-Revision-Date: 2017-08-14 23:51+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -10,33 +10,36 @@ msgstr "" msgid "" "---\n" -"title: \"&~? operator\"\n" +"title: \"&@* operator\"\n" "upper_level: ../\n" "---" msgstr "" "---\n" -"title: \"&~?演算子\"\n" +"title: \"&@*演算子\"\n" "upper_level: ../\n" "---" -msgid "# `&~?` operator" -msgstr "# `&~?`演算子" +msgid "# `&@*` operator" +msgstr "# `&@*`演算子" msgid "Since 1.2.1." msgstr "1.2.1で追加。" +msgid "`&~?` operator is deprecated since 1.2.2. Use `&@*` operator instead." +msgstr "`&~?`演算子は1.2.2から非推奨です。代わりに`&@*`演算子を使ってください。" + msgid "## Summary" msgstr "## 概要" -msgid "`&~?` operator performs similar search." -msgstr "`&~?`演算子は類似文書検索を実行します。" +msgid "`&@*` operator performs similar search." +msgstr "`&@*`演算子は類似文書検索を実行します。" msgid "## Syntax" msgstr "## 構文" msgid "" "```sql\n" -"column &~? document\n" +"column &@* document\n" "```" msgstr "" @@ -117,13 +120,13 @@ msgstr "" "```" msgid "" -"You can search records that are similar with the specified document by `&~?` o" +"You can search records that are similar with the specified document by `&@*` o" "perator:" -msgstr "`&~?`演算子を使うと指定した文書と似たレコードを検索できます。" +msgstr "`&@*`演算子を使うと指定した文書と似たレコードを検索できます。" msgid "" "```sql\n" -"SELECT * FROM memos WHERE content &~? 'Mroonga is a MySQL extension taht uses " +"SELECT * FROM memos WHERE content &@* 'Mroonga is a MySQL extension taht uses " "Groonga';\n" "-- id | content \n" "-- ----+----------------------------------------------------------------\n" @@ -132,7 +135,7 @@ msgid "" "```" msgstr "" "```sql\n" -"SELECT * FROM memos WHERE content &~? 'MroongaはGroongaを使うMySQLの拡張機能です。';\n" +"SELECT * FROM memos WHERE content &@* 'MroongaはGroongaを使うMySQLの拡張機能です。';\n" "-- id | content " " \n" "-- ----+----------------------------------------------------------------------" @@ -151,14 +154,14 @@ msgstr "シーケンシャルスキャンでは類似文書検索を使うこと msgid "" "```sql\n" -"SELECT * FROM memos WHERE content &~? 'Mroonga is a MySQL extension taht uses " +"SELECT * FROM memos WHERE content &@* 'Mroonga is a MySQL extension taht uses " "Groonga';\n" -"-- ERROR: pgroonga: operator &~? is available only in index scan\n" +"-- ERROR: pgroonga: operator &@* is available only in index scan\n" "```" msgstr "" "```sql\n" -"SELECT * FROM memos WHERE content &~? 'MroongaはGroongaを使うMySQLの拡張機能です。';\n" -"-- ERROR: pgroonga: operator &~? is available only in index scan\n" +"SELECT * FROM memos WHERE content &@* 'MroongaはGroongaを使うMySQLの拡張機能です。';\n" +"-- ERROR: pgroonga: operator &@* is available only in index scan\n" "```" msgid "## For Japanese" Modified: ja/reference/index.md (+4 -0) =================================================================== --- ja/reference/index.md 2017-08-14 23:09:02 +0900 (54c1f22) +++ ja/reference/index.md 2017-08-14 23:51:35 +0900 (653b70a) @@ -196,8 +196,12 @@ PGroonga 1.Y.Zは`pgroonga.XXX_v2`という演算子クラスを提供します * 新しく書くコードではこの演算子を使わないでください。後方互換製のために残っているだけの演算子です。 + * [`&@*`演算子][similar-search-v2]：類似文書検索 + * [`&~?`演算子][similar-search-v2]：類似文書検索 + * 1.2.2から非推奨です。代わりに[`&@*`演算子][similar-search-v2]を使ってください。 + * [`` &` ``演算子][script-v2]：ECMAScriptのようなクエリー言語を使った高度な検索 * [`&@|`演算子][match-in-v2]：キーワードの配列での全文検索 Modified: ja/reference/operators/similar-search-v2.md (+10 -8) =================================================================== --- ja/reference/operators/similar-search-v2.md 2017-08-14 23:09:02 +0900 (3cb675c) +++ ja/reference/operators/similar-search-v2.md 2017-08-14 23:51:35 +0900 (defaf16) @@ -1,20 +1,22 @@ --- -title: "&~?演算子" +title: "&@*演算子" upper_level: ../ --- -# `&~?`演算子 +# `&@*`演算子 1.2.1で追加。 +`&~?`演算子は1.2.2から非推奨です。代わりに`&@*`演算子を使ってください。 + ## 概要 -`&~?`演算子は類似文書検索を実行します。 +`&@*`演算子は類似文書検索を実行します。 ## 構文 ```sql -column &~? document +column &@* document ``` `column`は検索対象のカラムです。型は`text`型、`text[]`型、`varchar`型のどれかです。 @@ -54,10 +56,10 @@ INSERT INTO memos VALUES (3, 'PGroongaはインデックスとしてGroongaを INSERT INTO memos VALUES (4, 'groongaコマンドがあります。'); ``` -`&~?`演算子を使うと指定した文書と似たレコードを検索できます。 +`&@*`演算子を使うと指定した文書と似たレコードを検索できます。 ```sql -SELECT * FROM memos WHERE content &~? 'MroongaはGroongaを使うMySQLの拡張機能です。'; +SELECT * FROM memos WHERE content &@* 'MroongaはGroongaを使うMySQLの拡張機能です。'; -- id | content -- ----+--------------------------------------------------------------------------- -- 3 | PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。 @@ -69,8 +71,8 @@ SELECT * FROM memos WHERE content &~? 'MroongaはGroongaを使うMySQLの拡張 シーケンシャルスキャンでは類似文書検索を使うことはできません。シーケンシャルスキャンで類似文書検索を使うと次のエラーが返ります。 ```sql -SELECT * FROM memos WHERE content &~? 'MroongaはGroongaを使うMySQLの拡張機能です。'; --- ERROR: pgroonga: operator &~? is available only in index scan +SELECT * FROM memos WHERE content &@* 'MroongaはGroongaを使うMySQLの拡張機能です。'; +-- ERROR: pgroonga: operator &@* is available only in index scan ``` ## 日本語向け Modified: reference/operators/similar-search-v2.md (+10 -8) =================================================================== --- reference/operators/similar-search-v2.md 2017-08-14 23:09:02 +0900 (b369d6e) +++ reference/operators/similar-search-v2.md 2017-08-14 23:51:35 +0900 (a77c180) @@ -1,20 +1,22 @@ --- -title: "&~? operator" +title: "&@* operator" upper_level: ../ --- -# `&~?` operator +# `&@*` operator Since 1.2.1. +`&~?` operator is deprecated since 1.2.2. Use `&@*` operator instead. + ## Summary -`&~?` operator performs similar search. +`&@*` operator performs similar search. ## Syntax ```sql -column &~? document +column &@* document ``` `column` is a column to be searched. It's `text` type, `text[]` type or `varchar` type. @@ -54,10 +56,10 @@ INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groon INSERT INTO memos VALUES (4, 'There is groonga command.'); ``` -You can search records that are similar with the specified document by `&~?` operator: +You can search records that are similar with the specified document by `&@*` operator: ```sql -SELECT * FROM memos WHERE content &~? 'Mroonga is a MySQL extension taht uses Groonga'; +SELECT * FROM memos WHERE content &@* 'Mroonga is a MySQL extension taht uses Groonga'; -- id | content -- ----+---------------------------------------------------------------- -- 3 | PGroonga is a PostgreSQL extension that uses Groonga as index. @@ -69,8 +71,8 @@ SELECT * FROM memos WHERE content &~? 'Mroonga is a MySQL extension taht uses Gr You can't use similar search with sequential scan. If you use similar search with sequential search, you get the following error: ```sql -SELECT * FROM memos WHERE content &~? 'Mroonga is a MySQL extension taht uses Groonga'; --- ERROR: pgroonga: operator &~? is available only in index scan +SELECT * FROM memos WHERE content &@* 'Mroonga is a MySQL extension taht uses Groonga'; +-- ERROR: pgroonga: operator &@* is available only in index scan ``` ## For Japanese -------------- next part -------------- HTML����������������������������...Download