Kouhei Sutou
null+****@clear*****
Tue Jun 13 13:41:02 JST 2017
Kouhei Sutou 2017-06-13 13:41:02 +0900 (Tue, 13 Jun 2017) New Revision: 895b03938c17b1c6199a76c52b4fc7f7de11779c https://github.com/pgroonga/pgroonga.github.io/commit/895b03938c17b1c6199a76c52b4fc7f7de11779c Message: prefix-rk-search-in-v2 ja: translate Added files: _po/ja/reference/operators/prefix-rk-search-in-v2.po ja/reference/operators/prefix-rk-search-in-v2.md Modified files: _po/ja/reference/operators/prefix-rk-search-contain-v2.po _po/ja/reference/operators/prefix-rk-search-v2.po _po/ja/reference/operators/prefix-search-contain-v2.po _po/ja/reference/operators/prefix-search-v2.po ja/reference/operators/prefix-rk-search-contain-v2.md ja/reference/operators/prefix-search-v2.md reference/operators/prefix-rk-search-in-v2.md reference/operators/prefix-search-v2.md Modified: _po/ja/reference/operators/prefix-rk-search-contain-v2.po (+3 -142) =================================================================== --- _po/ja/reference/operators/prefix-rk-search-contain-v2.po 2017-06-10 14:15:11 +0900 (370d889) +++ _po/ja/reference/operators/prefix-rk-search-contain-v2.po 2017-06-13 13:41:02 +0900 (e0490c8) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2016-12-05 15:49+0900\n" +"PO-Revision-Date: 2017-06-13 13:21+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -12,150 +12,11 @@ msgid "" "---\n" "title: \"&^~> operator\"\n" "upper_level: ../\n" +"redirect: prefix-rk-search-v2.html\n" "---" msgstr "" "---\n" "title: \"&^~>演算子\"\n" "upper_level: ../\n" +"redirect: prefix-rk-search-v2.html\n" "---" - -msgid "# `&^~>` operator" -msgstr "# `&^~>`演算子" - -msgid "Since 1.0.9." -msgstr "1.0.9で追加。" - -msgid "## Summary" -msgstr "## 概要" - -msgid "" -"This operator uses v2 operator class. It doesn't provide backward compatibilit" -"y until PGroonga 2.0.0. Use it carefully." -msgstr "この演算子はv2演算子クラスを使います。v2演算子クラスはPGroonga 2.0.0まで互換性を提供しません。注意して使ってください。" - -msgid "" -"`&^~>` operator performs [prefix RK search](http://groonga.org/docs/reference/" -"operations/prefix_rk_search.html). R is for [Romaji](https://en.wikipedia.org/" -"wiki/Romanization_of_Japanese). K is for [Kana](https://en.wikipedia.org/wiki/" -"Kana)." -msgstr "" -"`&^~>`演算子は[前方一致RK検索](http://groonga.org/ja/docs/reference/operations/prefix_rk" -"_search.html)を実行します。Rはローマ字でKは仮名（ひらがなとカタカナ）という意味です。" - -msgid "Prefix RK search is useful for Japanese." -msgstr "前方一致RK検索は日本語を検索するときに便利です。" - -msgid "Prefix RK search is useful for implementing input completion." -msgstr "前方一致RK検索は入力補完機能を実装するときに便利です。" - -msgid "## Syntax" -msgstr "## 構文" - -msgid "" -"```sql\n" -"column &^~> prefix\n" -"```" -msgstr "" - -msgid "`column` is a column to be searched. It's `text[]` type." -msgstr "`column`は検索対象のカラムです。`text[]`型です。" - -msgid "`prefix` is a prefix to be found. It's `text` type." -msgstr "`prefix`は含まれているべきプレフィックスです。`text`型です。" - -msgid "" -"`column` values must be in Katakana. `prefix` must be in Romaji, Hiragana or K" -"atakana." -msgstr "`column`の値はカタカナにします。`prefix`はローマ字かひらがなかカタカナにします。" - -msgid "" -"The operator returns `true` when one of the `column` values start with `prefix" -"`." -msgstr "`column`のどれかの値が`prefix`から始まっていれば`true`を返します。" - -msgid "## Usage" -msgstr "## 使い方" - -msgid "Here are sample schema and data for examples:" -msgstr "例に使うサンプルスキーマとデータは次の通りです。" - -msgid "" -"```sql\n" -"CREATE TABLE tags (\n" -" name text PRIMARY KEY,\n" -" readings text[]\n" -");" -msgstr "" - -msgid "" -"CREATE INDEX pgroonga_tags_index ON tags\n" -" USING pgroonga (readings pgroonga.text_array_term_search_ops_v2);\n" -"```" -msgstr "" - -msgid "" -"```sql\n" -"INSERT INTO tags VALUES ('PostgreSQL',\n" -" ARRAY['ポストグレスキューエル', 'ポスグレ', 'ピージー']);\n" -"INSERT INTO tags VALUES ('Groonga', ARRAY['グルンガ']);\n" -"INSERT INTO tags VALUES ('PGroonga', ARRAY['ピージールンガ']);\n" -"INSERT INTO tags VALUES ('pglogical', ARRAY['ピージーロジカル']);\n" -"```" -msgstr "" - -msgid "You can perform prefix RK search with prefix in Romaji by `&^~>` operator:" -msgstr "`&^~>`演算子を使うとローマ字でプレフィックスを指定して前方一致RK検索を実行できます。" - -msgid "" -"```sql\n" -"SELECT * FROM tags WHERE readings &^~> 'pi-ji-';\n" -"-- name | readings \n" -"-- ------------+--------------------------------------------\n" -"-- PostgreSQL | {ポストグレスキューエル,ポスグレ,ピージー}\n" -"-- PGroonga | {ピージールンガ}\n" -"-- pglogical | {ピージーロジカル}\n" -"-- (3 rows)\n" -"```" -msgstr "" - -msgid "You can also use Hiragana for prefix:" -msgstr "プレフィックスにひらがなを使うこともできます。" - -msgid "" -"```sql\n" -"SELECT * FROM tags WHERE readings &^~> 'ぴーじー';\n" -"-- name | readings \n" -"-- ------------+--------------------------------------------\n" -"-- PostgreSQL | {ポストグレスキューエル,ポスグレ,ピージー}\n" -"-- PGroonga | {ピージールンガ}\n" -"-- pglogical | {ピージーロジカル}\n" -"-- (3 rows)\n" -"```" -msgstr "" - -msgid "You can also use Katakana for prefix:" -msgstr "プレフィックスにカタカナを使うこともできます。" - -msgid "" -"```sql\n" -"SELECT * FROM tags WHERE readings &^~> 'ピージー';\n" -"-- name | readings \n" -"-- ------------+--------------------------------------------\n" -"-- PostgreSQL | {ポストグレスキューエル,ポスグレ,ピージー}\n" -"-- PGroonga | {ピージールンガ}\n" -"-- pglogical | {ピージーロジカル}\n" -"-- (3 rows)\n" -"```" -msgstr "" - -msgid "## See also" -msgstr "## 参考" - -msgid " * [`&^` operator](prefix-search-v2.html)" -msgstr " * [`&^`演算子](prefix-search-v2.html)" - -msgid " * [`&^>` operator](prefix-search-contain-v2.html)" -msgstr " * [`&^>`演算子](prefix-search-contain-v2.html)" - -msgid " * [`&^~` operator](prefix-rk-search-v2.html)" -msgstr " * [`&^~`演算子](prefix-rk-search-v2.html)" Added: _po/ja/reference/operators/prefix-rk-search-in-v2.po (+196 -0) 100644 =================================================================== --- /dev/null +++ _po/ja/reference/operators/prefix-rk-search-in-v2.po 2017-06-13 13:41:02 +0900 (ce16c23) @@ -0,0 +1,196 @@ +msgid "" +msgstr "" +"Project-Id-Version: PACKAGE VERSION\n" +"PO-Revision-Date: 2017-06-13 13:38+0900\n" +"Language: ja\n" +"MIME-Version: 1.0\n" +"Content-Type: text/plain; charset=UTF-8\n" +"Content-Transfer-Encoding: 8bit\n" +"Plural-Forms: nplurals=1; plural=0;\n" + +msgid "" +"---\n" +"title: \"&^~| operator\"\n" +"upper_level: ../\n" +"---" +msgstr "" +"---\n" +"title: \"&^~|演算子\"\n" +"upper_level: ../\n" +"---" + +msgid "# `&^~|` operator" +msgstr "# `&^~|`演算子" + +msgid "Since 1.2.1." +msgstr "1.2.1で追加。" + +msgid "## Summary" +msgstr "## 概要" + +msgid "" +"`&^~|` operator performs [prefix RK search][groonga-prefix-rk-search] by an ar" +"ray of prefixes. R is for [Romaji][wikipedia-romaji]. K is for [Katakana][wiki" +"pedia-katakana]. If one ore more prefixes are matched, the record is matched." +msgstr "" +"`&^~>`演算子は[前方一致RK検索](http://groonga.org/ja/docs/reference/operations/prefix_rk" +"_search.html)を実行します。Rは[ローマ字][wikipedia-romaji]でKは[カタカナ][wikipedia-katakana]という" +"意味です。配列の中の1つ以上のプレフィックスがマッチしたらそのレコードはマッチしたことになります。" + +msgid "Prefix RK search is useful for Japanese." +msgstr "前方一致RK検索は日本語を検索するときに便利です。" + +msgid "Prefix RK search is useful for implementing input completion." +msgstr "前方一致RK検索は入力補完機能を実装するときに便利です。" + +msgid "## Syntax" +msgstr "## 構文" + +msgid "" +"```sql\n" +"column &^~| prefixes\n" +"```" +msgstr "" + +msgid "`column` is a column to be searched. It's `text` type or `text[]` type." +msgstr "`column`は検索対象のカラムです。型は`text`型か`text[]`型です。" + +msgid "`prefixes` is an array of prefixes to be found. It's `text[]` type." +msgstr "`prefixes`は検索したいプレフィックスの配列です。型は`text[]`型です。" + +msgid "" +"`column` values must be in Katakana. `prefixes` must be in Romaji, Hiragana or" +" Katakana." +msgstr "`column`の値はカタカナにします。`prefixes`はローマ字かひらがなかカタカナにします。" + +msgid "" +"The operator returns `true` when the `column` value starts with one or more pr" +"efixes in `prefixes`." +msgstr "この演算子は`column`の値が`prefixes`中の1つ以上のプレフィックスから始まっていれば`true`を返します。" + +msgid "## Operator classes" +msgstr "## 演算子クラス" + +msgid "" +"You need to specify one of the following operator classes to use this operator" +":" +msgstr "この演算子を使うには次のどれかの演算子クラスを指定する必要があります。" + +msgid " * `pgroonga.text_term_search_ops_v2`: For `text`" +msgstr " * `pgroonga.text_term_search_ops_v2`：`text`用" + +msgid " * `pgroonga.text_array_term_search_ops_v2`: For `text[]`" +msgstr " * `pgroonga.text_array_term_search_ops_v2`：`text[]`用" + +msgid "## Usage" +msgstr "## 使い方" + +msgid "Here are sample schema and data for examples:" +msgstr "例に使うサンプルスキーマとデータは次の通りです。" + +msgid "" +"```sql\n" +"CREATE TABLE tags (\n" +" name text PRIMARY KEY,\n" +" reading text\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_tags_index ON tags\n" +" USING pgroonga (reading pgroonga.text_term_search_ops_v2);\n" +"```" +msgstr "" + +msgid "" +"```sql\n" +"INSERT INTO tags VALUES ('PostgreSQL',\n" +" 'ポストグレスキューエル');\n" +"INSERT INTO tags VALUES ('Groonga', 'グルンガ');\n" +"INSERT INTO tags VALUES ('PGroonga', 'ピージールンガ');\n" +"INSERT INTO tags VALUES ('pglogical', 'ピージーロジカル');\n" +"```" +msgstr "" + +msgid "You can perform prefix RK search with prefixes in Romaji by `&^~|` operator:" +msgstr "`&^~|`演算子を使うとローマ字でプレフィックスを複数指定して前方一致RK検索を実行できます。" + +msgid "" +"```sql\n" +"SELECT * FROM tags WHERE reading &^~| ARRAY['pi-ji-', 'posu'];\n" +"-- name | reading \n" +"-- ------------+------------------------\n" +"-- PostgreSQL | ポストグレスキューエル\n" +"-- PGroonga | ピージールンガ\n" +"-- pglogical | ピージーロジカル\n" +"-- (3 rows)\n" +"```" +msgstr "" + +msgid "You can also use Hiragana for prefixes:" +msgstr "プレフィックスにはひらがなを使うこともできます。" + +msgid "" +"```sql\n" +"SELECT * FROM tags WHERE reading &^~| ARRAY['ぴーじー', 'ぽす'];\n" +"-- name | reading \n" +"-- ------------+------------------------\n" +"-- PostgreSQL | ポストグレスキューエル\n" +"-- PGroonga | ピージールンガ\n" +"-- pglogical | ピージーロジカル\n" +"-- (3 rows)\n" +"```" +msgstr "" + +msgid "You can also use Katakana for prefixes:" +msgstr "プレフィックスにカタカナを使うこともできます。" + +msgid "" +"```sql\n" +"SELECT * FROM tags WHERE reading &^~| ARRAY['ピージー', 'ポス'];\n" +"-- name | reading \n" +"-- ------------+------------------------\n" +"-- PostgreSQL | ポストグレスキューエル\n" +"-- PGroonga | ピージールンガ\n" +"-- pglogical | ピージーロジカル\n" +"-- (3 rows)\n" +"```" +msgstr "" + +msgid "## See also" +msgstr "## 参考" + +msgid " * [`&^` operator][prefix-search-v2]: Prefix search" +msgstr " * [`&^`演算子][prefix-search-v2]：前方一致検索" + +msgid "" +" * [`&^|` operator][prefix-search-in-v2]: Prefix search by an array of prefix" +"es" +msgstr " * [`&^|`演算子][prefix-search-in-v2]：プレフィックスの配列での前方一致検索" + +msgid " * [`&^~` operator][prefix-rk-search-v2]: Prefix RK search" +msgstr " * [`&^~`演算子][prefix-rk-search-v2]：前方一致RK検索" + +msgid "" +"[groonga-prefix-rk-search]:http://groonga.org/docs/reference/operations/prefix" +"_rk_search.html" +msgstr "" +"[groonga-prefix-rk-search]:http://groonga.org/ja/docs/reference/operations/pre" +"fix_rk_search.html" + +msgid "[wikipedia-romaji]:https://en.wikipedia.org/wiki/Romanization_of_Japanese" +msgstr "" +"[wikipedia-romaji]:https://ja.wikipedia.org/wiki/%E3%83%AD%E3%83%BC%E3%83%9E%E" +"5%AD%97" + +msgid "[wikipedia-katakana]:https://en.wikipedia.org/wiki/Katakana" +msgstr "[wikipedia-katakana]:https://ja.wikipedia.org/wiki/%E7%89%87%E4%BB%AE%E5%90%8D" + +msgid "[prefix-search-v2]:prefix-search-v2.html" +msgstr "" + +msgid "[prefix-search-in-v2]:prefix-search-in-v2.html" +msgstr "" + +msgid "[prefix-rk-search-v2]:prefix-rk-search-v2.html" +msgstr "" Modified: _po/ja/reference/operators/prefix-rk-search-v2.po (+1 -1) =================================================================== --- _po/ja/reference/operators/prefix-rk-search-v2.po 2017-06-10 14:15:11 +0900 (c454d81) +++ _po/ja/reference/operators/prefix-rk-search-v2.po 2017-06-13 13:41:02 +0900 (f685e02) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2017-06-10 14:07+0900\n" +"PO-Revision-Date: 2017-06-13 13:27+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" Modified: _po/ja/reference/operators/prefix-search-contain-v2.po (+3 -95) =================================================================== --- _po/ja/reference/operators/prefix-search-contain-v2.po 2017-06-10 14:15:11 +0900 (bdbb755) +++ _po/ja/reference/operators/prefix-search-contain-v2.po 2017-06-13 13:41:02 +0900 (891e7d4) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2016-12-05 15:49+0900\n" +"PO-Revision-Date: 2017-06-10 14:14+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -12,103 +12,11 @@ msgid "" "---\n" "title: \"&^> operator\"\n" "upper_level: ../\n" +"redirect: prefix-search-v2.html\n" "---" msgstr "" "---\n" "title: \"&^>演算子\"\n" "upper_level: ../\n" +"redirect: prefix-search-v2.html\n" "---" - -msgid "# `&^>` operator" -msgstr "# `&^>`演算子" - -msgid "Since 1.0.9." -msgstr "1.0.9で追加。" - -msgid "## Summary" -msgstr "## 概要" - -msgid "" -"This operator uses v2 operator class. It doesn't provide backward compatibilit" -"y until PGroonga 2.0.0. Use it carefully." -msgstr "この演算子はv2演算子クラスを使います。v2演算子クラスはPGroonga 2.0.0まで互換性を提供しません。注意して使ってください。" - -msgid "`&^>` operator performs prefix search." -msgstr "`&^>`演算子は前方一致検索を実行します。" - -msgid "Prefix search is useful for implementing input completion." -msgstr "前方一致検索は入力補完機能を実現する場合に便利です。" - -msgid "## Syntax" -msgstr "## 構文" - -msgid "" -"```sql\n" -"column &^> prefix\n" -"```" -msgstr "" - -msgid "`column` is a column to be searched. It's `text[]` type." -msgstr "`column`は検索対象のカラムです。`text[]`型です。" - -msgid "`prefix` is a prefix to be found. It's `text` type." -msgstr "`prefix`は含まれているべきプレフィックスです。`text`型です。" - -msgid "" -"The operator returns `true` when one of the `column` values start with `prefix" -"`." -msgstr "`column`のどれかの値が`prefix`から始まっていれば`true`を返します。" - -msgid "## Usage" -msgstr "## 使い方" - -msgid "Here are sample schema and data for examples:" -msgstr "例に使うサンプルスキーマとデータは次の通りです。" - -msgid "" -"```sql\n" -"CREATE TABLE tags (\n" -" name text PRIMARY KEY,\n" -" aliases text[]\n" -");" -msgstr "" - -msgid "" -"CREATE INDEX pgroonga_tag_aliases_index ON tags\n" -" USING pgroonga (aliases pgroonga.text_array_term_search_ops_v2);\n" -"```" -msgstr "" - -msgid "" -"```sql\n" -"INSERT INTO tags VALUES ('PostgreSQL', ARRAY['PostgreSQL', 'PG']);\n" -"INSERT INTO tags VALUES ('Groonga', ARRAY['Groonga', 'grn']);\n" -"INSERT INTO tags VALUES ('PGroonga', ARRAY['PGroonga', 'pgrn']);\n" -"```" -msgstr "" - -msgid "You can perform prefix search with prefix by `&^>` operator:" -msgstr "`&^>`演算子を使うと指定したプレフィックスで前方一致検索を実行できます。" - -msgid "" -"```sql\n" -"SELECT * FROM tags WHERE aliases &^> 'pg';\n" -"-- name | aliases \n" -"-- ------------+-----------------\n" -"-- PostgreSQL | {PostgreSQL,PG}\n" -"-- PGroonga | {PGroonga,pgrn}\n" -"-- (2 rows)\n" -"```" -msgstr "" - -msgid "## See also" -msgstr "## 参考" - -msgid " * [`&^` operator](prefix-search-v2.html)" -msgstr " * [`&^`演算子](prefix-search-v2.html)" - -msgid " * [`&^~` operator](prefix-rk-search-v2.html)" -msgstr " * [`&^~`演算子](prefix-rk-search-v2.html)" - -msgid " * [`&^~>` operator](prefix-rk-search-contain-v2.html)" -msgstr " * [`&^~>`演算子](prefix-rk-search-contain-v2.html)" Modified: _po/ja/reference/operators/prefix-search-v2.po (+7 -1) =================================================================== --- _po/ja/reference/operators/prefix-search-v2.po 2017-06-10 14:15:11 +0900 (e8dc935) +++ _po/ja/reference/operators/prefix-search-v2.po 2017-06-13 13:41:02 +0900 (97bc856) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2017-06-10 14:12+0900\n" +"PO-Revision-Date: 2017-06-13 13:38+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -131,3 +131,9 @@ msgstr " * [`&^~|`演算子][prefix-rk-search-in-v2]：プレフィックスの msgid "[prefix-rk-search-v2]:prefix-rk-search-v2.html" msgstr "" + +msgid "[prefix-search-in-v2]:prefix-search-in-v2.html" +msgstr "" + +msgid "[prefix-rk-search-in-v2]:prefix-rk-search-in-v2.html" +msgstr "" Modified: ja/reference/operators/prefix-rk-search-contain-v2.md (+1 -94) =================================================================== --- ja/reference/operators/prefix-rk-search-contain-v2.md 2017-06-10 14:15:11 +0900 (21c8b14) +++ ja/reference/operators/prefix-rk-search-contain-v2.md 2017-06-13 13:41:02 +0900 (8e143ac) @@ -1,98 +1,5 @@ --- title: "&^~>演算子" upper_level: ../ +redirect: prefix-rk-search-v2.html --- - -# `&^~>`演算子 - -1.0.9で追加。 - -## 概要 - -この演算子はv2演算子クラスを使います。v2演算子クラスはPGroonga 2.0.0まで互換性を提供しません。注意して使ってください。 - -`&^~>`演算子は[前方一致RK検索](http://groonga.org/ja/docs/reference/operations/prefix_rk_search.html)を実行します。Rはローマ字でKは仮名（ひらがなとカタカナ）という意味です。 - -前方一致RK検索は日本語を検索するときに便利です。 - -前方一致RK検索は入力補完機能を実装するときに便利です。 - -## 構文 - -```sql -column &^~> prefix -``` - -`column`は検索対象のカラムです。`text[]`型です。 - -`prefix`は含まれているべきプレフィックスです。`text`型です。 - -`column`の値はカタカナにします。`prefix`はローマ字かひらがなかカタカナにします。 - -`column`のどれかの値が`prefix`から始まっていれば`true`を返します。 - -## 使い方 - -例に使うサンプルスキーマとデータは次の通りです。 - -```sql -CREATE TABLE tags ( - name text PRIMARY KEY, - readings text[] -); - -CREATE INDEX pgroonga_tags_index ON tags - USING pgroonga (readings pgroonga.text_array_term_search_ops_v2); -``` - -```sql -INSERT INTO tags VALUES ('PostgreSQL', - ARRAY['ポストグレスキューエル', 'ポスグレ', 'ピージー']); -INSERT INTO tags VALUES ('Groonga', ARRAY['グルンガ']); -INSERT INTO tags VALUES ('PGroonga', ARRAY['ピージールンガ']); -INSERT INTO tags VALUES ('pglogical', ARRAY['ピージーロジカル']); -``` - -`&^~>`演算子を使うとローマ字でプレフィックスを指定して前方一致RK検索を実行できます。 - -```sql -SELECT * FROM tags WHERE readings &^~> 'pi-ji-'; --- name | readings --- ------------+-------------------------------------------- --- PostgreSQL | {ポストグレスキューエル,ポスグレ,ピージー} --- PGroonga | {ピージールンガ} --- pglogical | {ピージーロジカル} --- (3 rows) -``` - -プレフィックスにひらがなを使うこともできます。 - -```sql -SELECT * FROM tags WHERE readings &^~> 'ぴーじー'; --- name | readings --- ------------+-------------------------------------------- --- PostgreSQL | {ポストグレスキューエル,ポスグレ,ピージー} --- PGroonga | {ピージールンガ} --- pglogical | {ピージーロジカル} --- (3 rows) -``` - -プレフィックスにカタカナを使うこともできます。 - -```sql -SELECT * FROM tags WHERE readings &^~> 'ピージー'; --- name | readings --- ------------+-------------------------------------------- --- PostgreSQL | {ポストグレスキューエル,ポスグレ,ピージー} --- PGroonga | {ピージールンガ} --- pglogical | {ピージーロジカル} --- (3 rows) -``` - -## 参考 - - * [`&^`演算子](prefix-search-v2.html) - - * [`&^>`演算子](prefix-search-contain-v2.html) - - * [`&^~`演算子](prefix-rk-search-v2.html) Added: ja/reference/operators/prefix-rk-search-in-v2.md (+116 -0) 100644 =================================================================== --- /dev/null +++ ja/reference/operators/prefix-rk-search-in-v2.md 2017-06-13 13:41:02 +0900 (11034ca) @@ -0,0 +1,116 @@ +--- +title: "&^~|演算子" +upper_level: ../ +--- + +# `&^~|`演算子 + +1.2.1で追加。 + +## 概要 + +`&^~>`演算子は[前方一致RK検索](http://groonga.org/ja/docs/reference/operations/prefix_rk_search.html)を実行します。Rは[ローマ字][wikipedia-romaji]でKは[カタカナ][wikipedia-katakana]という意味です。配列の中の1つ以上のプレフィックスがマッチしたらそのレコードはマッチしたことになります。 + +前方一致RK検索は日本語を検索するときに便利です。 + +前方一致RK検索は入力補完機能を実装するときに便利です。 + +## 構文 + +```sql +column &^~| prefixes +``` + +`column`は検索対象のカラムです。型は`text`型か`text[]`型です。 + +`prefixes`は検索したいプレフィックスの配列です。型は`text[]`型です。 + +`column`の値はカタカナにします。`prefixes`はローマ字かひらがなかカタカナにします。 + +この演算子は`column`の値が`prefixes`中の1つ以上のプレフィックスから始まっていれば`true`を返します。 + +## 演算子クラス + +この演算子を使うには次のどれかの演算子クラスを指定する必要があります。 + + * `pgroonga.text_term_search_ops_v2`：`text`用 + + * `pgroonga.text_array_term_search_ops_v2`：`text[]`用 + +## 使い方 + +例に使うサンプルスキーマとデータは次の通りです。 + +```sql +CREATE TABLE tags ( + name text PRIMARY KEY, + reading text +); + +CREATE INDEX pgroonga_tags_index ON tags + USING pgroonga (reading pgroonga.text_term_search_ops_v2); +``` + +```sql +INSERT INTO tags VALUES ('PostgreSQL', + 'ポストグレスキューエル'); +INSERT INTO tags VALUES ('Groonga', 'グルンガ'); +INSERT INTO tags VALUES ('PGroonga', 'ピージールンガ'); +INSERT INTO tags VALUES ('pglogical', 'ピージーロジカル'); +``` + +`&^~|`演算子を使うとローマ字でプレフィックスを複数指定して前方一致RK検索を実行できます。 + +```sql +SELECT * FROM tags WHERE reading &^~| ARRAY['pi-ji-', 'posu']; +-- name | reading +-- ------------+------------------------ +-- PostgreSQL | ポストグレスキューエル +-- PGroonga | ピージールンガ +-- pglogical | ピージーロジカル +-- (3 rows) +``` + +プレフィックスにはひらがなを使うこともできます。 + +```sql +SELECT * FROM tags WHERE reading &^~| ARRAY['ぴーじー', 'ぽす']; +-- name | reading +-- ------------+------------------------ +-- PostgreSQL | ポストグレスキューエル +-- PGroonga | ピージールンガ +-- pglogical | ピージーロジカル +-- (3 rows) +``` + +プレフィックスにカタカナを使うこともできます。 + +```sql +SELECT * FROM tags WHERE reading &^~| ARRAY['ピージー', 'ポス']; +-- name | reading +-- ------------+------------------------ +-- PostgreSQL | ポストグレスキューエル +-- PGroonga | ピージールンガ +-- pglogical | ピージーロジカル +-- (3 rows) +``` + +## 参考 + + * [`&^`演算子][prefix-search-v2]：前方一致検索 + + * [`&^|`演算子][prefix-search-in-v2]：プレフィックスの配列での前方一致検索 + + * [`&^~`演算子][prefix-rk-search-v2]：前方一致RK検索 + +[groonga-prefix-rk-search]:http://groonga.org/ja/docs/reference/operations/prefix_rk_search.html + +[wikipedia-romaji]:https://ja.wikipedia.org/wiki/%E3%83%AD%E3%83%BC%E3%83%9E%E5%AD%97 + +[wikipedia-katakana]:https://ja.wikipedia.org/wiki/%E7%89%87%E4%BB%AE%E5%90%8D + +[prefix-search-v2]:prefix-search-v2.html + +[prefix-search-in-v2]:prefix-search-in-v2.html + +[prefix-rk-search-v2]:prefix-rk-search-v2.html Modified: ja/reference/operators/prefix-search-v2.md (+5 -0) =================================================================== --- ja/reference/operators/prefix-search-v2.md 2017-06-10 14:15:11 +0900 (a72f6fd) +++ ja/reference/operators/prefix-search-v2.md 2017-06-13 13:41:02 +0900 (492de75) @@ -75,3 +75,8 @@ SELECT * FROM tags WHERE name &^ 'pg'; * [`&^~|`演算子][prefix-rk-search-in-v2]：プレフィックスの配列での前方一致RK検索 [prefix-rk-search-v2]:prefix-rk-search-v2.html + +[prefix-search-in-v2]:prefix-search-in-v2.html + +[prefix-rk-search-in-v2]:prefix-rk-search-in-v2.html + Modified: reference/operators/prefix-rk-search-in-v2.md (+6 -6) =================================================================== --- reference/operators/prefix-rk-search-in-v2.md 2017-06-10 14:15:11 +0900 (f4c8536) +++ reference/operators/prefix-rk-search-in-v2.md 2017-06-13 13:41:02 +0900 (8638df7) @@ -18,14 +18,14 @@ Prefix RK search is useful for implementing input completion. ## Syntax ```sql -column &^~| prefix +column &^~| prefixes ``` `column` is a column to be searched. It's `text` type or `text[]` type. -`prefix` is an array of prefixes to be found. It's `text[]` type. +`prefixes` is an array of prefixes to be found. It's `text[]` type. -`column` values must be in Katakana. `prefix` must be in Romaji, Hiragana or Katakana. +`column` values must be in Katakana. `prefixes` must be in Romaji, Hiragana or Katakana. The operator returns `true` when the `column` value starts with one or more prefixes in `prefixes`. @@ -97,11 +97,11 @@ SELECT * FROM tags WHERE reading &^~| ARRAY['ピージー', 'ポス']; ## See also - * [`&^` operator][prefix-search-v2] + * [`&^` operator][prefix-search-v2]: Prefix search - * [`&^|` operator][prefix-search-in-v2] + * [`&^|` operator][prefix-search-in-v2]: Prefix search by an array of prefixes - * [`&^~` operator][prefix-rk-search-v2] + * [`&^~` operator][prefix-rk-search-v2]: Prefix RK search [groonga-prefix-rk-search]:http://groonga.org/docs/reference/operations/prefix_rk_search.html Modified: reference/operators/prefix-search-v2.md (+5 -0) =================================================================== --- reference/operators/prefix-search-v2.md 2017-06-10 14:15:11 +0900 (25ad147) +++ reference/operators/prefix-search-v2.md 2017-06-13 13:41:02 +0900 (cd1094b) @@ -75,3 +75,8 @@ SELECT * FROM tags WHERE name &^ 'pg'; * [`&^~|` operator][prefix-rk-search-in-v2]: Prefix RK search by an array of prefixes [prefix-rk-search-v2]:prefix-rk-search-v2.html + +[prefix-search-in-v2]:prefix-search-in-v2.html + +[prefix-rk-search-in-v2]:prefix-rk-search-in-v2.html + -------------- next part -------------- HTML����������������������������...下載
