Kouhei Sutou
null+****@clear*****
Sat Jun 10 09:17:35 JST 2017
Kouhei Sutou 2017-06-10 09:17:35 +0900 (Sat, 10 Jun 2017) New Revision: a382815083582772e62566d5162dae5a121473ad https://github.com/pgroonga/pgroonga.github.io/commit/a382815083582772e62566d5162dae5a121473ad Message: contain-term ja: translate Added files: _po/ja/reference/operators/contain-term.po Copied files: ja/reference/operators/contain-term.md (from reference/operators/contain-term.md) Modified files: reference/operators/contain-term.md Added: _po/ja/reference/operators/contain-term.po (+119 -0) 100644 =================================================================== --- /dev/null +++ _po/ja/reference/operators/contain-term.po 2017-06-10 09:17:35 +0900 (59d517a) @@ -0,0 +1,119 @@ +msgid "" +msgstr "" +"Project-Id-Version: PACKAGE VERSION\n" +"PO-Revision-Date: 2017-06-10 09:16+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 varchar[]\"\n" +"upper_level: ../\n" +"---" +msgstr "" +"---\n" +"title: \"varchar[]用の%%演算子\"\n" +"upper_level: ../\n" +"---" + +msgid "# `%%` operator for `varchar[]`" +msgstr "# `varchar[]`用の`%%`演算子" + +msgid "## Summary" +msgstr "## 概要" + +msgid "" +"This operator is deprecated since 1.2.1. Use [`&>` operator][contain-term-v2] " +"instead." +msgstr "" + +msgid "`%%` operator checks whether a term is included in an array of terms." +msgstr "" + +msgid "## Syntax" +msgstr "## 構文" + +msgid "" +"```sql\n" +"column %% term\n" +"```" +msgstr "" + +msgid "`column` is a column to be searched. It's `varchar[]` type." +msgstr "`column`は検索対象のカラムです。型は`varchar[]`型です。" + +msgid "`term` is a term to be found. It's `varchar` type." +msgstr "`term`は検索条件の単語です。型は`varchar`です。" + +msgid "## Operator classes" +msgstr "## 演算子クラス" + +msgid "" +"You need to specify one of the following operator classes to use this operator" +":" +msgstr "この演算子を使うには次のどれかの演算子クラスを指定する必要があります。" + +msgid " * `pgroonga.varchar_array_ops`: Default for `varchar[]`" +msgstr " * `pgroonga.varchar_array_ops`：`varchar[]`型のデフォルト" + +msgid " * `pgroonga.varchar_array_term_search_ops`: For `varchar[]`" +msgstr " * `pgroonga.varchar_array_term_search_ops`：`varchar[]`用" + +msgid "## Usage" +msgstr "## 使い方" + +msgid "Here are sample schema and data for examples:" +msgstr "例に使うサンプルスキーマとデータは次の通りです。" + +msgid "" +"```sql\n" +"CREATE TABLE memos (\n" +" id integer,\n" +" tags varchar(255)[]\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_tags_index ON memos USING pgroonga (tags);\n" +"```" +msgstr "" + +msgid "" +"```sql\n" +"INSERT INTO memos VALUES (1, ARRAY['PostgreSQ']);\n" +"INSERT INTO memos VALUES (2, ARRAY['Groonga']);\n" +"INSERT INTO memos VALUES (3, ARRAY['PGroonga', 'PostgreSQL', 'Groonga']);\n" +"INSERT INTO memos VALUES (4, ARRAY['Groonga']);\n" +"```" +msgstr "" + +msgid "" +"You can find records that contain `'Groonga'` term in an array of terms by `%%" +"` operator:" +msgstr "`%%`演算子を使うと単語の配列中から`'Groonga'`という単語を含むレコードを検索できます。" + +msgid "" +"```sql\n" +"SELECT * FROM memos WHERE tags %% 'Groonga';\n" +"-- id | tags \n" +"-- ----+-------------------------------\n" +"-- 2 | {Groonga}\n" +"-- 3 | {PGroonga,PostgreSQL,Groonga}\n" +"-- 4 | {Groonga}\n" +"-- (3 rows)\n" +"```" +msgstr "" + +msgid "## See also" +msgstr "## 参考" + +msgid "" +" * [`&>` operator][contain-term-v2]: Check whether a term is included in an a" +"rray of terms" +msgstr " * [`&>`演算子][contain-term-v2]：検索対象の単語の配列に指定した単語が含まれているかをチェック" + +msgid "[contain-term-v2]:contain-term-v2.html" +msgstr "" Copied: ja/reference/operators/contain-term.md (+15 -15) 50% =================================================================== --- reference/operators/contain-term.md 2017-06-10 09:11:28 +0900 (4c82505) +++ ja/reference/operators/contain-term.md 2017-06-10 09:17:35 +0900 (7feda8c) @@ -1,37 +1,37 @@ --- -title: "%% operator for varchar[]" +title: "varchar[]用の%%演算子" upper_level: ../ --- -# `&>` operator for `varchar[]` +# `varchar[]`用の`%%`演算子 -## Summary +## 概要 This operator is deprecated since 1.2.1. Use [`&>` operator][contain-term-v2] instead. `%%` operator checks whether a term is included in an array of terms. -## Syntax +## 構文 ```sql column %% term ``` -`column` is a column to be searched. It's `varchar[]` type. +`column`は検索対象のカラムです。型は`varchar[]`型です。 -`term` is a term to be found. It's `varchar` type. +`term`は検索条件の単語です。型は`varchar`です。 -## Operator classes +## 演算子クラス -You need to specify one of the following operator classes to use this operator: +この演算子を使うには次のどれかの演算子クラスを指定する必要があります。 - * `pgroonga.varchar_array_ops`: Default for `varchar[]` + * `pgroonga.varchar_array_ops`：`varchar[]`型のデフォルト - * `pgroonga.varchar_array_term_search_ops`: For `varchar[]` + * `pgroonga.varchar_array_term_search_ops`：`varchar[]`用 -## Usage +## 使い方 -Here are sample schema and data for examples: +例に使うサンプルスキーマとデータは次の通りです。 ```sql CREATE TABLE memos ( @@ -49,7 +49,7 @@ INSERT INTO memos VALUES (3, ARRAY['PGroonga', 'PostgreSQL', 'Groonga']); INSERT INTO memos VALUES (4, ARRAY['Groonga']); ``` -You can find records that contain `'Groonga'` term in an array of terms by `%%` operator: +`%%`演算子を使うと単語の配列中から`'Groonga'`という単語を含むレコードを検索できます。 ```sql SELECT * FROM memos WHERE tags %% 'Groonga'; @@ -61,8 +61,8 @@ SELECT * FROM memos WHERE tags %% 'Groonga'; -- (3 rows) ``` -## See also +## 参考 - * [`&>` operator][contain-term-v2] + * [`&>`演算子][contain-term-v2]：検索対象の単語の配列に指定した単語が含まれているかをチェック [contain-term-v2]:contain-term-v2.html Modified: reference/operators/contain-term.md (+2 -2) =================================================================== --- reference/operators/contain-term.md 2017-06-10 09:11:28 +0900 (4c82505) +++ reference/operators/contain-term.md 2017-06-10 09:17:35 +0900 (d69a143) @@ -3,7 +3,7 @@ title: "%% operator for varchar[]" upper_level: ../ --- -# `&>` operator for `varchar[]` +# `%%` operator for `varchar[]` ## Summary @@ -63,6 +63,6 @@ SELECT * FROM memos WHERE tags %% 'Groonga'; ## See also - * [`&>` operator][contain-term-v2] + * [`&>` operator][contain-term-v2]: Check whether a term is included in an array of terms [contain-term-v2]:contain-term-v2.html -------------- next part -------------- HTML����������������������������...Download