Kouhei Sutou
null+****@clear*****
Sun Oct 25 21:55:44 JST 2015
Kouhei Sutou 2015-10-25 21:55:44 +0900 (Sun, 25 Oct 2015) New Revision: 9d96e5105a7be8f577b9cafdaa9b14683395c637 https://github.com/pgroonga/pgroonga.github.io/commit/9d96e5105a7be8f577b9cafdaa9b14683395c637 Message: Use English for sample data Modified files: _po/ja/reference/functions/pgroonga-table-name.po reference/functions/pgroonga-table-name.md Modified: _po/ja/reference/functions/pgroonga-table-name.po (+69 -4) =================================================================== --- _po/ja/reference/functions/pgroonga-table-name.po 2015-10-25 21:50:21 +0900 (709d02b) +++ _po/ja/reference/functions/pgroonga-table-name.po 2015-10-25 21:55:44 +0900 (c9bf9c3) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2015-10-24 17:16+0900\n" +"PO-Revision-Date: 2015-10-25 21:55+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -94,6 +94,25 @@ msgid "" "INSERT INTO terms\n" " VALUES (1,\n" " 'PostgreSQL',\n" +" 'PostgreSQL is a relational database management system.',\n" +" 'PostgreSQL');\n" +"INSERT INTO terms\n" +" VALUES (2,\n" +" 'Groonga',\n" +" 'Groonga is a fast full text search engine that supports all lang" +"uages.',\n" +" 'Groonga');\n" +"INSERT INTO terms\n" +" VALUES (3,\n" +" 'PGroonga',\n" +" 'PGroonga is a PostgreSQL extension that uses Groonga as index.'," +"\n" +" 'PostgreSQL');\n" +"```" +msgstr "" +"INSERT INTO terms\n" +" VALUES (1,\n" +" 'PostgreSQL',\n" " 'PostgreSQLはリレーショナル・データベース管理システムです。',\n" " 'PostgreSQL');\n" "INSERT INTO terms\n" @@ -107,7 +126,6 @@ msgid "" " 'PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。',\n" " 'PostgreSQL');\n" "```" -msgstr "" msgid "" "You can use [`match_columns` option](http://groonga.org/docs/reference/command" @@ -124,6 +142,32 @@ msgid "" " pgroonga.table_name('pgroonga_terms_index') || ' ' |" "|\n" " '--match_columns \"title * 10 || content\" ' ||\n" +" '--query \"Groonga OR PostgreSQL OR engine\" ' ||\n" +" '--output_columns \"_score, title, content\" ' ||\n" +" '--sortby \"-_score\"'\n" +" )::json->1->0);\n" +"-- value " +" \n" +"-- ---------------------------------------------------------------------------" +"--------------\n" +"-- [3]\n" +"-- [[\"_score\",\"Int32\"],[\"title\",\"LongText\"],[\"content\",\"LongText\"]]\n" +"-- [12,\"Groonga\",\"Groonga is a fast full text search engine that supports all" +" languages.\"]\n" +"-- [11,\"PostgreSQL\",\"PostgreSQL is a relational database management system.\"]" +"\n" +"-- [2,\"PGroonga\",\"PGroonga is a PostgreSQL extension that uses Groonga as ind" +"ex.\"]\n" +"-- (5 rows)\n" +"```" +msgstr "" +"```sql\n" +"SELECT *\n" +" FROM json_array_elements(\n" +" pgroonga.command('select ' ||\n" +" pgroonga.table_name('pgroonga_terms_index') || ' ' |" +"|\n" +" '--match_columns \"title * 10 || content\" ' ||\n" " '--query \"Groonga OR PostgreSQL OR 全文検索\" ' ||\n" " '--output_columns \"_score, title, content\" ' ||\n" " '--sortby \"-_score\"'\n" @@ -139,7 +183,6 @@ msgid "" "-- [2,\"PGroonga\",\"PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。\"]\n" "-- (5 rows)\n" "```" -msgstr "" msgid "" "You can use drilldown feature by [`drilldown` option](http://groonga.org/docs/" @@ -156,7 +199,7 @@ msgid "" " pgroonga.table_name('pgroonga_terms_index') || ' ' |" "|\n" " '--match_columns \"title * 10 || content\" ' ||\n" -" '--query \"Groonga OR PostgreSQL OR 全文検索\" ' ||\n" +" '--query \"Groonga OR PostgreSQL OR engine\" ' ||\n" " '--output_columns \"_score, title\" ' ||\n" " '--sortby \"-_score\" ' ||\n" " '--drilldown \"tag\"'\n" @@ -172,6 +215,28 @@ msgid "" "-- (2 rows)\n" "```" msgstr "" +"```sql\n" +"SELECT *\n" +" FROM json_array_elements(\n" +" pgroonga.command('select ' ||\n" +" pgroonga.table_name('pgroonga_terms_index') || ' ' |" +"|\n" +" '--match_columns \"title * 10 || content\" ' ||\n" +" '--query \"Groonga OR PostgreSQL OR 全文検索\" ' ||\n" +" '--output_columns \"_score, title\" ' ||\n" +" '--sortby \"-_score\" ' ||\n" +" '--drilldown \"tag\"'\n" +" )::json->1);\n" +"-- value " +" \n" +"-- ---------------------------------------------------------------------------" +"----------------------\n" +"-- [[3],[[\"_score\",\"Int32\"],[\"title\",\"LongText\"]],[12,\"Groonga\"],[11,\"Postgre" +"SQL\"],[2,\"PGroonga\"]]\n" +"-- [[2],[[\"_key\",\"ShortText\"],[\"_nsubrecs\",\"Int32\"]],[\"Groonga\",1],[\"PostgreS" +"QL\",2]]\n" +"-- (2 rows)\n" +"```" msgid "`select` Groonga command may help you when `SELECT` statement in SQL is slow." msgstr "Groongaの`select`コマンドはSQLの`SELECT`分が遅いときの手段として使えます。" Modified: reference/functions/pgroonga-table-name.md (+10 -10) =================================================================== --- reference/functions/pgroonga-table-name.md 2015-10-25 21:50:21 +0900 (70f90ce) +++ reference/functions/pgroonga-table-name.md 2015-10-25 21:55:44 +0900 (8b949d7) @@ -42,17 +42,17 @@ CREATE INDEX pgroonga_terms_index INSERT INTO terms VALUES (1, 'PostgreSQL', - 'PostgreSQLはリレーショナル・データベース管理システムです。', + 'PostgreSQL is a relational database management system.', 'PostgreSQL'); INSERT INTO terms VALUES (2, 'Groonga', - 'Groongaは日本語対応の高速な全文検索エンジンです。', + 'Groonga is a fast full text search engine that supports all languages.', 'Groonga'); INSERT INTO terms VALUES (3, 'PGroonga', - 'PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。', + 'PGroonga is a PostgreSQL extension that uses Groonga as index.', 'PostgreSQL'); ``` @@ -64,17 +64,17 @@ SELECT * pgroonga.command('select ' || pgroonga.table_name('pgroonga_terms_index') || ' ' || '--match_columns "title * 10 || content" ' || - '--query "Groonga OR PostgreSQL OR 全文検索" ' || + '--query "Groonga OR PostgreSQL OR engine" ' || '--output_columns "_score, title, content" ' || '--sortby "-_score"' )::json->1->0); --- value --- -------------------------------------------------------------------------------------------- +-- value +-- ----------------------------------------------------------------------------------------- -- [3] -- [["_score","Int32"],["title","LongText"],["content","LongText"]] --- [12,"Groonga","Groongaは日本語対応の高速な全文検索エンジンです。"] --- [11,"PostgreSQL","PostgreSQLはリレーショナル・データベース管理システムです。"] --- [2,"PGroonga","PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。"] +-- [12,"Groonga","Groonga is a fast full text search engine that supports all languages."] +-- [11,"PostgreSQL","PostgreSQL is a relational database management system."] +-- [2,"PGroonga","PGroonga is a PostgreSQL extension that uses Groonga as index."] -- (5 rows) ``` @@ -86,7 +86,7 @@ SELECT * pgroonga.command('select ' || pgroonga.table_name('pgroonga_terms_index') || ' ' || '--match_columns "title * 10 || content" ' || - '--query "Groonga OR PostgreSQL OR 全文検索" ' || + '--query "Groonga OR PostgreSQL OR engine" ' || '--output_columns "_score, title" ' || '--sortby "-_score" ' || '--drilldown "tag"' -------------- next part -------------- HTML����������������������������...Download