Kouhei Sutou
null+****@clear*****
Sat Jun 10 09:22:40 JST 2017
Kouhei Sutou 2017-06-10 09:22:40 +0900 (Sat, 10 Jun 2017) New Revision: 851f7ecf776b4df79056d34f274c97b8fa89898b https://github.com/pgroonga/pgroonga.github.io/commit/851f7ecf776b4df79056d34f274c97b8fa89898b Message: match-jsonb-v2 ja: translate Added files: _po/ja/reference/operators/match-jsonb-v2.po Copied files: ja/reference/operators/match-jsonb-v2.md (from reference/operators/match-jsonb-v2.md) Modified files: reference/operators/match-jsonb-v2.md Added: _po/ja/reference/operators/match-jsonb-v2.po (+173 -0) 100644 =================================================================== --- /dev/null +++ _po/ja/reference/operators/match-jsonb-v2.po 2017-06-10 09:22:40 +0900 (0862ee6) @@ -0,0 +1,173 @@ +msgid "" +msgstr "" +"Project-Id-Version: PACKAGE VERSION\n" +"PO-Revision-Date: 2017-06-10 09:21+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 for jsonb type\"\n" +"upper_level: ../\n" +"---" +msgstr "" +"---\n" +"title: \"jsonb型用の&@演算子\"\n" +"upper_level: ../\n" +"---" + +msgid "# `&@` operator for `jsonb` type" +msgstr "# `jsonb`型用の`&@`演算子" + +msgid "Since 1.2.1." +msgstr "1.2.1で追加。" + +msgid "## Summary" +msgstr "## 概要" + +msgid "" +"`&@` operator performs full text search against all texts in `jsonb` by one ke" +"yword." +msgstr "`&@`演算子は`jsonb`内のすべてのテキストに対して1つのキーワードで全文検索を実行します。" + +msgid "## Syntax" +msgstr "## 構文" + +msgid "" +"```sql\n" +"column &@ keyword\n" +"```" +msgstr "" + +msgid "`column` is a column to be searched. It's `jsonb` type." +msgstr "`column`は検索対象のカラムです。型は`jsonb`型です。" + +msgid "`keyword` is a keyword for full text search. It's `text` type." +msgstr "`keyword`は全文検索で使うキーワードです。型は`text`型です。" + +msgid "## Operator classes" +msgstr "## 演算子クラス" + +msgid "" +"You need to specify one of the following operator classes to use this operator" +":" +msgstr "この演算子を使うには次のどれかの演算子クラスを指定する必要があります。" + +msgid " * `pgroonga.jsonb_ops`: Default for `jsonb`" +msgstr " * `pgroonga.jsonb_ops`：`jsonb`型のデフォルト" + +msgid " * `pgroonga.jsonb_ops_v2`: For `jsonb`" +msgstr " * `pgroonga.jsonb_ops_v2`：`jsonb`型用" + +msgid "## Usage" +msgstr "## 使い方" + +msgid "Here are sample schema and data for examples:" +msgstr "例に使うサンプルスキーマとデータは次の通りです。" + +msgid "" +"```sql\n" +"CREATE TABLE logs (\n" +" record jsonb\n" +");" +msgstr "" + +msgid "CREATE INDEX pgroonga_logs_index ON logs USING pgroonga (record);" +msgstr "" + +msgid "" +"INSERT INTO logs\n" +" VALUES ('{\n" +" \"message\": \"Server is started.\",\n" +" \"host\": \"www.example.com\",\n" +" \"tags\": [\n" +" \"web\",\n" +" \"example.com\"\n" +" ]\n" +" }');\n" +"INSERT INTO logs\n" +" VALUES ('{\n" +" \"message\": \"GET /\",\n" +" \"host\": \"www.example.com\",\n" +" \"code\": 200,\n" +" \"tags\": [\n" +" \"web\",\n" +" \"example.com\"\n" +" ]\n" +" }');\n" +"INSERT INTO logs\n" +" VALUES ('{\n" +" \"message\": \"Send to <info �� example.com>.\",\n" +" \"host\": \"mail.example.net\",\n" +" \"tags\": [\n" +" \"mail\",\n" +" \"example.net\"\n" +" ]\n" +" }');\n" +"```" +msgstr "" + +msgid "You can perform full text search with one keyword by `&@`:" +msgstr "`&@`演算子を使うと1つのキーワードで全文検索できます。" + +msgid "" +"(It uses [`jsonb_pretty()` function][postgresql-jsonb-pretty] provided since P" +"ostgreSQL 9.5 for readability.)" +msgstr "" +"（読みやすくするためにPostgreSQL 9.5以降で使える[`jsonb_pretty()`関数][postgresql-jsonb-pretty]を使" +"っています。）" + +msgid "" +"```sql\n" +"SELECT jsonb_pretty(record) FROM logs WHERE record &@ 'server';\n" +"-- jsonb_pretty \n" +"-- -------------------------------------\n" +"-- { +\n" +"-- \"host\": \"www.example.com\", +\n" +"-- \"tags\": [ +\n" +"-- \"web\", +\n" +"-- \"example.com\" +\n" +"-- ], +\n" +"-- \"message\": \"Server is started.\"+\n" +"-- }\n" +"-- (1 row)\n" +"```" +msgstr "" + +msgid "## See also" +msgstr "## 参考" + +msgid " * [`jsonb` support][jsonb]" +msgstr " * [`jsonb`サポート][jsonb]" + +msgid "" +" * [`&?` operator][query-jsonb-v2]: Full text search against all text data in" +" `jsonb` by easy to use query language" +msgstr " * [`&?`演算子][query-jsonb-v2]：`jsonb`内のすべてのテキストデータを便利なクエリー言語を使った全文検索" + +msgid "" +" * [`` &` `` operator][script-jsonb-v2]: Advanced search by ECMAScript like q" +"uery language" +msgstr " * [`` &` ``演算子][script-jsonb-v2]：ECMAScriptのようなクエリー言語を使った高度な検索" + +msgid " * [`@>` operator][contain-jsonb]: Search by a `jsonb` data" +msgstr " * [`@>`演算子][contain-jsonb]：`jsonb`データを使った検索" + +msgid "[jsonb]:../jsonb.html" +msgstr "" + +msgid "" +"[query-jsonb-v2]:query-jsonb-v2.html\n" +"[script-jsonb-v2]:script-jsonb-v2.html\n" +"[contain-jsonb]:contain-jsonb.html" +msgstr "" + +msgid "" +"[postgresql-jsonb-pretty]:{{ site.postgresql_doc_base_url.en }}/functions-json" +".html#FUNCTIONS-JSON-PROCESSING-TABLE" +msgstr "" +"[postgresql-jsonb-pretty]:{{ site.postgresql_doc_base_url.ja }}/functions-json" +".html#FUNCTIONS-JSON-PROCESSING-TABLE" Copied: ja/reference/operators/match-jsonb-v2.md (+23 -23) 53% =================================================================== --- reference/operators/match-jsonb-v2.md 2017-06-10 09:17:35 +0900 (b9de0bd) +++ ja/reference/operators/match-jsonb-v2.md 2017-06-10 09:22:40 +0900 (b527ecf) @@ -1,37 +1,37 @@ --- -title: "&@ operator for jsonb type" +title: "jsonb型用の&@演算子" upper_level: ../ --- -# `&@` operator for `jsonb` type +# `jsonb`型用の`&@`演算子 -Since 1.2.1. +1.2.1で追加。 -## Summary +## 概要 -`&@` operator performs full text search against all texts in `jsonb` by one keyword. +`&@`演算子は`jsonb`内のすべてのテキストに対して1つのキーワードで全文検索を実行します。 -## Syntax +## 構文 ```sql column &@ keyword ``` -`column` is a column to be searched. It's `jsonb` type. +`column`は検索対象のカラムです。型は`jsonb`型です。 -`keyword` is a keyword for full text search. It's `text` type. +`keyword`は全文検索で使うキーワードです。型は`text`型です。 -## Operator classes +## 演算子クラス -You need to specify one of the following operator classes to use this operator: +この演算子を使うには次のどれかの演算子クラスを指定する必要があります。 - * `pgroonga.jsonb_ops`: Default for `jsonb` + * `pgroonga.jsonb_ops`：`jsonb`型のデフォルト - * `pgroonga.jsonb_ops_v2`: For `jsonb` + * `pgroonga.jsonb_ops_v2`：`jsonb`型用 -## Usage +## 使い方 -Here are sample schema and data for examples: +例に使うサンプルスキーマとデータは次の通りです。 ```sql CREATE TABLE logs ( @@ -70,9 +70,9 @@ INSERT INTO logs }'); ``` -You can perform full text search with one keyword by `&@`: +`&@`演算子を使うと1つのキーワードで全文検索できます。 -(It uses [`jsonb_pretty()` function][postgresql-jsonb-pretty] provided since PostgreSQL 9.5 for readability.) +（読みやすくするためにPostgreSQL 9.5以降で使える[`jsonb_pretty()`関数][postgresql-jsonb-pretty]を使っています。） ```sql SELECT jsonb_pretty(record) FROM logs WHERE record &@ 'server'; @@ -89,20 +89,20 @@ SELECT jsonb_pretty(record) FROM logs WHERE record &@ 'server'; -- (1 row) ``` -## See also +## 参考 - * [`jsonb` support][jsonb] + * [`jsonb`サポート][jsonb] - * [`&?` operator][query-jsonb-v2]: Full text search against all text data in `jsonb` by easy to use query language + * [`&?`演算子][query-jsonb-v2]：`jsonb`内のすべてのテキストデータを便利なクエリー言語を使った全文検索 - * [`` &` `` operator][script-jsonb-v2]: Advanced search by ECMAScript like query language + * [`` &` ``演算子][script-jsonb-v2]：ECMAScriptのようなクエリー言語を使った高度な検索 - * [`@>` operator][contain-jsonb]: Search by a `jsonb` data + * [`@>`演算子][contain-jsonb]：`jsonb`データを使った検索 [jsonb]:../jsonb.html -[match-jsonb-v2]:match-jsonb-v2.html +[query-jsonb-v2]:query-jsonb-v2.html [script-jsonb-v2]:script-jsonb-v2.html [contain-jsonb]:contain-jsonb.html -[postgresql-jsonb-pretty]:{{ site.postgresql_doc_base_url.en }}/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE +[postgresql-jsonb-pretty]:{{ site.postgresql_doc_base_url.ja }}/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE Modified: reference/operators/match-jsonb-v2.md (+1 -1) =================================================================== --- reference/operators/match-jsonb-v2.md 2017-06-10 09:17:35 +0900 (b9de0bd) +++ reference/operators/match-jsonb-v2.md 2017-06-10 09:22:40 +0900 (14857d6) @@ -101,7 +101,7 @@ SELECT jsonb_pretty(record) FROM logs WHERE record &@ 'server'; [jsonb]:../jsonb.html -[match-jsonb-v2]:match-jsonb-v2.html +[query-jsonb-v2]:query-jsonb-v2.html [script-jsonb-v2]:script-jsonb-v2.html [contain-jsonb]:contain-jsonb.html -------------- next part -------------- HTML����������������������������...下載
