Kouhei Sutou
null+****@clear*****
Sat Jun 10 14:15:11 JST 2017
Kouhei Sutou 2017-06-10 14:15:11 +0900 (Sat, 10 Jun 2017) New Revision: b051fbbc6b116bf198a3ff7dac60221e3c7e6469 https://github.com/pgroonga/pgroonga.github.io/commit/b051fbbc6b116bf198a3ff7dac60221e3c7e6469 Message: prefix-search-in-v2 ja: translate Added files: _po/ja/reference/operators/prefix-search-in-v2.po ja/reference/operators/prefix-search-in-v2.md Modified files: _po/ja/reference/operators/prefix-search-v2.po ja/reference/operators/prefix-search-contain-v2.md ja/reference/operators/prefix-search-v2.md reference/operators/prefix-search-in-v2.md reference/operators/prefix-search-v2.md Added: _po/ja/reference/operators/prefix-search-in-v2.po (+138 -0) 100644 =================================================================== --- /dev/null +++ _po/ja/reference/operators/prefix-search-in-v2.po 2017-06-10 14:15:11 +0900 (c27c42d) @@ -0,0 +1,138 @@ +msgid "" +msgstr "" +"Project-Id-Version: PACKAGE VERSION\n" +"PO-Revision-Date: 2017-06-10 14:12+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 search by an array of prefixes. If one or more " +"prefixes are matched, the record is matched." +msgstr "`&^|`演算子はプレフィックスの配列を使って前方一致検索をします。配列の中の1つ以上のプレフィックスがマッチしたらそのレコードはマッチしたことになります。" + +msgid "Prefix search is useful for implementing input completion." +msgstr "前方一致検索は入力補完機能を実現する場合に便利です。" + +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 "" +"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" +" alias text\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_tag_alias_index ON tags\n" +" USING pgroonga (alias pgroonga.text_term_search_ops_v2);\n" +"```" +msgstr "" + +msgid "" +"```sql\n" +"INSERT INTO tags VALUES ('PostgreSQL', 'PG');\n" +"INSERT INTO tags VALUES ('Groonga', 'grn');\n" +"INSERT INTO tags VALUES ('PGroonga', 'pgrn');\n" +"INSERT INTO tags VALUES ('Mroonga', 'mrn');\n" +"```" +msgstr "" + +msgid "You can perform prefix search with prefixes by `&^|` operator:" +msgstr "" + +msgid "" +"```sql\n" +"SELECT * FROM tags WHERE alias &^| ARRAY['pg', 'mrn'];\n" +"-- name | alias \n" +"-- ------------+-------\n" +"-- PostgreSQL | PG\n" +"-- PGroonga | pgrn\n" +"-- Mroonga | mrn\n" +"-- (3 rows)\n" +"```" +msgstr "" + +msgid "## See also" +msgstr "## 参考" + +msgid " * [`&^` operator][prefix-search-v2]: Prefix search" +msgstr " * [`&^`演算子][prefix-search-v2]：前方一致検索" + +msgid " * [`&^~` operator][prefix-rk-search-v2]: Prefix RK search" +msgstr " * [`&^~`演算子][prefix-rk-search-v2]：前方一致RK検索" + +msgid "" +" * [`&^~|` operator][prefix-rk-search-in-v2]: Prefix RK search by an array of" +" prefixes" +msgstr " * [`&^~|`演算子][prefix-rk-search-in-v2]：プレフィックスの配列での前方一致RK検索" + +msgid "[prefix-search-v2]:prefix-search-v2.html" +msgstr "" + +msgid "[prefix-rk-search-v2]:prefix-rk-search-v2.html" +msgstr "" + +msgid "[prefix-rk-search-in-v2]:prefix-rk-search-in-v2.html" +msgstr "" Modified: _po/ja/reference/operators/prefix-search-v2.po (+11 -1) =================================================================== --- _po/ja/reference/operators/prefix-search-v2.po 2017-06-10 14:08:01 +0900 (b7d7689) +++ _po/ja/reference/operators/prefix-search-v2.po 2017-06-10 14:15:11 +0900 (e8dc935) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2017-06-10 13:55+0900\n" +"PO-Revision-Date: 2017-06-10 14:12+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -119,5 +119,15 @@ msgstr "## 参考" msgid " * [`&^~` operator][prefix-rk-search-v2]: Prefix RK search" msgstr " * [`&^~`演算子][prefix-rk-search-v2]：前方一致RK検索" +msgid "" +" * [`&^|` operator][prefix-search-in-v2]: Prefix search by an array of prefix" +"es" +msgstr " * [`&^|`演算子][prefix-search-in-v2]：プレフィックスの配列での前方一致検索" + +msgid "" +" * [`&^~|` operator][prefix-rk-search-in-v2]: Prefix RK search by an array of" +" prefixes" +msgstr " * [`&^~|`演算子][prefix-rk-search-in-v2]：プレフィックスの配列での前方一致RK検索" + msgid "[prefix-rk-search-v2]:prefix-rk-search-v2.html" msgstr "" Modified: ja/reference/operators/prefix-search-contain-v2.md (+1 -63) =================================================================== --- ja/reference/operators/prefix-search-contain-v2.md 2017-06-10 14:08:01 +0900 (3e3b48b) +++ ja/reference/operators/prefix-search-contain-v2.md 2017-06-10 14:15:11 +0900 (2d9b9d8) @@ -1,67 +1,5 @@ --- title: "&^>演算子" upper_level: ../ +redirect: prefix-search-v2.html --- - -# `&^>`演算子 - -1.0.9で追加。 - -## 概要 - -この演算子はv2演算子クラスを使います。v2演算子クラスはPGroonga 2.0.0まで互換性を提供しません。注意して使ってください。 - -`&^>`演算子は前方一致検索を実行します。 - -前方一致検索は入力補完機能を実現する場合に便利です。 - -## 構文 - -```sql -column &^> prefix -``` - -`column`は検索対象のカラムです。`text[]`型です。 - -`prefix`は含まれているべきプレフィックスです。`text`型です。 - -`column`のどれかの値が`prefix`から始まっていれば`true`を返します。 - -## 使い方 - -例に使うサンプルスキーマとデータは次の通りです。 - -```sql -CREATE TABLE tags ( - name text PRIMARY KEY, - aliases text[] -); - -CREATE INDEX pgroonga_tag_aliases_index ON tags - USING pgroonga (aliases pgroonga.text_array_term_search_ops_v2); -``` - -```sql -INSERT INTO tags VALUES ('PostgreSQL', ARRAY['PostgreSQL', 'PG']); -INSERT INTO tags VALUES ('Groonga', ARRAY['Groonga', 'grn']); -INSERT INTO tags VALUES ('PGroonga', ARRAY['PGroonga', 'pgrn']); -``` - -`&^>`演算子を使うと指定したプレフィックスで前方一致検索を実行できます。 - -```sql -SELECT * FROM tags WHERE aliases &^> 'pg'; --- name | aliases --- ------------+----------------- --- PostgreSQL | {PostgreSQL,PG} --- PGroonga | {PGroonga,pgrn} --- (2 rows) -``` - -## 参考 - - * [`&^`演算子](prefix-search-v2.html) - - * [`&^~`演算子](prefix-rk-search-v2.html) - - * [`&^~>`演算子](prefix-rk-search-contain-v2.html) Added: ja/reference/operators/prefix-search-in-v2.md (+81 -0) 100644 =================================================================== --- /dev/null +++ ja/reference/operators/prefix-search-in-v2.md 2017-06-10 14:15:11 +0900 (a221c79) @@ -0,0 +1,81 @@ +--- +title: "&^|演算子" +upper_level: ../ +--- + +# `&^|`演算子 + +1.2.1で追加。 + +## 概要 + +`&^|`演算子はプレフィックスの配列を使って前方一致検索をします。配列の中の1つ以上のプレフィックスがマッチしたらそのレコードはマッチしたことになります。 + +前方一致検索は入力補完機能を実現する場合に便利です。 + +## 構文 + +```sql +column &^| prefixes +``` + +`column`は検索対象のカラムです。型は`text`型か`text[]`型です。 + +`prefixes`は検索したいプレフィックスの配列です。型は`text[]`型です。 + +この演算子は`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, + alias text +); + +CREATE INDEX pgroonga_tag_alias_index ON tags + USING pgroonga (alias pgroonga.text_term_search_ops_v2); +``` + +```sql +INSERT INTO tags VALUES ('PostgreSQL', 'PG'); +INSERT INTO tags VALUES ('Groonga', 'grn'); +INSERT INTO tags VALUES ('PGroonga', 'pgrn'); +INSERT INTO tags VALUES ('Mroonga', 'mrn'); +``` + +You can perform prefix search with prefixes by `&^|` operator: + +```sql +SELECT * FROM tags WHERE alias &^| ARRAY['pg', 'mrn']; +-- name | alias +-- ------------+------- +-- PostgreSQL | PG +-- PGroonga | pgrn +-- Mroonga | mrn +-- (3 rows) +``` + +## 参考 + + * [`&^`演算子][prefix-search-v2]：前方一致検索 + + * [`&^~`演算子][prefix-rk-search-v2]：前方一致RK検索 + + * [`&^~|`演算子][prefix-rk-search-in-v2]：プレフィックスの配列での前方一致RK検索 + +[prefix-search-v2]:prefix-search-v2.html + +[prefix-rk-search-v2]:prefix-rk-search-v2.html + +[prefix-rk-search-in-v2]:prefix-rk-search-in-v2.html Modified: ja/reference/operators/prefix-search-v2.md (+4 -0) =================================================================== --- ja/reference/operators/prefix-search-v2.md 2017-06-10 14:08:01 +0900 (976658c) +++ ja/reference/operators/prefix-search-v2.md 2017-06-10 14:15:11 +0900 (a72f6fd) @@ -70,4 +70,8 @@ SELECT * FROM tags WHERE name &^ 'pg'; * [`&^~`演算子][prefix-rk-search-v2]：前方一致RK検索 + * [`&^|`演算子][prefix-search-in-v2]：プレフィックスの配列での前方一致検索 + + * [`&^~|`演算子][prefix-rk-search-in-v2]：プレフィックスの配列での前方一致RK検索 + [prefix-rk-search-v2]:prefix-rk-search-v2.html Modified: reference/operators/prefix-search-in-v2.md (+3 -3) =================================================================== --- reference/operators/prefix-search-in-v2.md 2017-06-10 14:08:01 +0900 (7604e42) +++ reference/operators/prefix-search-in-v2.md 2017-06-10 14:15:11 +0900 (f748678) @@ -68,11 +68,11 @@ SELECT * FROM tags WHERE alias &^| ARRAY['pg', 'mrn']; ## See also - * [`&^` operator][prefix-search-v2] + * [`&^` operator][prefix-search-v2]: Prefix search - * [`&^~` operator][prefix-rk-search-v2] + * [`&^~` operator][prefix-rk-search-v2]: Prefix RK search - * [`&^~|` operator][prefix-rk-search-in-v2] + * [`&^~|` operator][prefix-rk-search-in-v2]: Prefix RK search by an array of prefixes [prefix-search-v2]:prefix-search-v2.html Modified: reference/operators/prefix-search-v2.md (+4 -0) =================================================================== --- reference/operators/prefix-search-v2.md 2017-06-10 14:08:01 +0900 (cb3f1ba) +++ reference/operators/prefix-search-v2.md 2017-06-10 14:15:11 +0900 (25ad147) @@ -70,4 +70,8 @@ SELECT * FROM tags WHERE name &^ 'pg'; * [`&^~` operator][prefix-rk-search-v2]: Prefix RK search + * [`&^|` operator][prefix-search-in-v2]: Prefix search by an array of prefixes + + * [`&^~|` operator][prefix-rk-search-in-v2]: Prefix RK search by an array of prefixes + [prefix-rk-search-v2]:prefix-rk-search-v2.html -------------- next part -------------- HTML����������������������������...Download