<!DOCTYPE html>
<html>
<head>
</head>
<body>
<dl style="line-height: 1.5; margin-left: 2em">
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Author</dt>
<dd style="margin-left: 8.5em">Kouhei Sutou <kou****@clear*****></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt>
<dd style="margin-left: 8.5em">2015-10-07 00:12:49 +0900 (Wed, 07 Oct 2015)</dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">New Revision</dt>
<dd style="margin-left: 8.5em"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee">0184ba5f4a42b977bd0c14ca398f9769eb0a15ee</a></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt>
<dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">Translate query operator</pre></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Modified files</dt>
<dd style="margin-left: 8.5em">
<ul>
<li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35cc">reference/operators/query.md</a></li>
</ul>
</dd>
</dl>
<div class="diff-section" style="clear: both">
<table style="border-collapse: collapse; border: 1px solid #aaa">
<thead>
<tr class="diff-header" style="border: 1px solid #aaa">
<td colspan="3">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: reference/operators/query.md (+4 -9)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL4">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL7">7</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL8">8</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL9">9</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL12">12</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL16">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL19">19</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL20">20</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL21">21</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL22">22</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL23">23</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL24">24</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL25">25</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL26">26</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL27">27</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL28">28</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccL29">29</a></span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR4">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR7">7</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR8">8</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR11">11</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR15">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR18">18</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR20">20</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR21">21</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR22">22</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR23">23</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0184ba5f4a42b977bd0c14ca398f9769eb0a15ee#diff-05a62d3f005775702d62b1df842a35ccR24">24</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -5,8 +5,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">layout: en</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> # `@@` operator</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-`キーワード1 OR キーワード2`のようにクエリー構文を使って全文検索をする</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-ときは`@@`演算子を使います。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+You can do full text search with multiple keywords by `@@` operator like `KEYWORD1 KEYWORD2`. You can also do OR search by `KEYWORD1 OR KEYWORD2`:</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```sql</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT * FROM memos WHERE content @@ 'PGroonga OR PostgreSQL';</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -17,13 +16,9 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">SELECT * FROM memos WHERE content @@ 'PGroonga OR PostgreSQL';</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> -- (2 行)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-クエリー構文の詳細は</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-[Groognaのドキュメント](http://groonga.org/ja/docs/reference/grn_expr/query_syntax.html)</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-を参照してください。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+See [Groogna document](http://groonga.org/docs/reference/grn_expr/query_syntax.html) for query syntax details.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-ただし、`カラム名:@キーワード`というように「`カラム名:`」から始まる構</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-文は無効にしてあります。そのため、前方一致検索をしたい場合は「`カラム</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-名:^値`」という構文は使えず、「`値*`」という構文だけが使えます。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+Note that you can't use syntax that starts with `COLUMN_NAME:` like `COLUMN_NAME:@KEYWORD`. It's disabled in PGroonga.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-注意してください。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+You can't use `COLUMN_NAME:^VALUE` for prefix search. You need to use `VALUE*` for prefix search.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>