<!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-08 23:11:29 +0900 (Thu, 08 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/35d9b5db5663f97af67cf705982833e4d950da34">35d9b5db5663f97af67cf705982833e4d950da34</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">Copy JSON content It's not translated yet.</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/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1d">tutorial/index.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"> Modified: tutorial/index.md (+304 -0) =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL426">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL427">427</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL428">428</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL429">429</a>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL430">430</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL431">431</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL432">432</a> </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"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR426">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR427">427</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR428">428</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR429">429</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR430">430</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR431">431</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR432">432</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR433">433</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR434">434</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR435">435</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR436">436</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR437">437</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR438">438</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR439">439</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR440">440</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR441">441</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR442">442</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR443">443</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR444">444</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR445">445</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR446">446</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR447">447</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR448">448</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR449">449</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR450">450</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR451">451</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR452">452</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR453">453</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR454">454</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR455">455</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR456">456</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR457">457</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR458">458</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR459">459</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR460">460</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR461">461</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR462">462</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR463">463</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR464">464</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR465">465</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR466">466</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR467">467</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR468">468</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR469">469</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR470">470</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR471">471</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR472">472</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR473">473</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR474">474</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR475">475</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR476">476</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR477">477</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR478">478</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR479">479</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR480">480</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR481">481</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR482">482</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR483">483</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR484">484</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR485">485</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR486">486</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR487">487</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR488">488</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR489">489</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR490">490</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR491">491</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR492">492</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR493">493</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR494">494</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR495">495</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR496">496</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR497">497</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR498">498</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR499">499</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR500">500</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR501">501</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR502">502</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR503">503</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR504">504</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR505">505</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR506">506</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR507">507</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR508">508</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR509">509</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR510">510</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR511">511</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR512">512</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR513">513</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR514">514</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR515">515</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR516">516</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR517">517</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR518">518</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR519">519</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR520">520</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR521">521</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR522">522</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR523">523</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR524">524</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR525">525</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR526">526</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR527">527</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR528">528</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR529">529</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR530">530</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR531">531</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR532">532</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR533">533</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR534">534</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR535">535</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR536">536</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR537">537</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR538">538</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR539">539</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR540">540</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR541">541</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR542">542</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR543">543</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR544">544</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR545">545</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR546">546</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR547">547</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR548">548</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR549">549</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR550">550</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR551">551</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR552">552</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR553">553</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR554">554</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR555">555</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR556">556</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR557">557</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR558">558</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR559">559</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR560">560</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR561">561</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR562">562</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR563">563</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR564">564</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR565">565</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR566">566</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR567">567</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR568">568</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR569">569</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR570">570</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR571">571</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR572">572</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR573">573</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR574">574</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR575">575</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR576">576</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR577">577</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR578">578</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR579">579</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR580">580</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR581">581</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR582">582</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR583">583</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR584">584</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR585">585</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR586">586</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR587">587</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR588">588</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR589">589</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR590">590</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR591">591</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR592">592</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR593">593</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR594">594</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR595">595</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR596">596</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR597">597</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR598">598</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR599">599</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR600">600</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR601">601</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR602">602</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR603">603</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR604">604</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR605">605</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR606">606</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR607">607</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR608">608</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR609">609</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR610">610</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR611">611</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR612">612</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR613">613</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR614">614</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR615">615</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR616">616</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR617">617</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR618">618</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR619">619</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR620">620</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR621">621</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR622">622</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR623">623</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR624">624</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR625">625</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR626">626</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR627">627</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR628">628</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR629">629</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR630">630</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR631">631</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR632">632</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR633">633</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR634">634</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR635">635</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR636">636</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR637">637</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR638">638</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR639">639</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR640">640</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR641">641</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR642">642</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR643">643</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR644">644</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR645">645</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR646">646</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR647">647</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR648">648</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR649">649</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR650">650</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR651">651</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR652">652</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR653">653</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR654">654</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR655">655</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR656">656</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR657">657</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR658">658</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR659">659</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR660">660</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR661">661</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR662">662</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR663">663</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR664">664</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR665">665</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR666">666</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR667">667</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR668">668</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR669">669</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR670">670</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR671">671</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR672">672</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR673">673</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR674">674</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR675">675</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR676">676</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR677">677</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR678">678</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR679">679</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR680">680</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR681">681</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR682">682</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR683">683</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR684">684</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR685">685</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR686">686</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR687">687</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR688">688</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR689">689</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR690">690</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR691">691</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR692">692</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR693">693</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR694">694</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR695">695</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR696">696</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR697">697</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR698">698</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR699">699</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR700">700</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR701">701</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR702">702</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR703">703</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR704">704</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR705">705</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR706">706</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR707">707</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR708">708</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR709">709</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR710">710</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR711">711</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR712">712</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR713">713</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR714">714</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR715">715</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR716">716</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR717">717</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR718">718</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR719">719</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR720">720</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR721">721</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR722">722</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR723">723</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR724">724</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR725">725</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR726">726</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR727">727</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR728">728</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR729">729</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR730">730</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR731">731</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR732">732</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR733">733</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR734">734</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR735">735</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/35d9b5db5663f97af67cf705982833e4d950da34#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR736">736</a> </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">@@ -427,6 +427,310 @@ SELECT * FROM products WHERE tags %% 'PostgreSQL'; -- (2 行) ``` +{: #json} + +## How to use PGroonga for JSON + +TODO: Split details to reference/ + +PGroongaは`jsonb`型のデータもサポートしています。PGroongaのインデック +スを作成することにより高速に検索できます。 + +PGroongaは`jsonb`の検索のために次の2つの演算子を提供しています。 + + * `@>`演算子 + * `@@`演算子 + +[`@>`演算子はPostgreSQLが標準で提供している演算子](http://www.postgresql.org/docs/current/static/functions-json.html#FUNCTIONS-JSONB-OP-TABLE) +です。右辺が左辺のサブセットなら真になります。 + +`@>`演算子はGINでも高速化できる演算子です。インデックス作成時間は +PGroongaとGINでそれほど変わりませんが、検索時間はPGroongaの方が少し速 +いです。 + +`@@`演算子はPGroonga独自の演算子です。GINではインデックスを使えない複 +雑な検索条件も記述できます。もし、 +[JsQuery](https://github.com/postgrespro/jsquery)を知っているなら +構文が違うJsQueryのようなものと考えてください。 + +JsQueryができる検索とPGroongaができる検索はほぼ同じですが、PGroongaだ +けができる特徴的な検索は全文字列値に対しての全文検索です。 + +たとえば、次のJSONがあるとします。 + +```json +{ + "message": "Server is started.", + "host": "www.example.com", + "tags": [ + "web", + ] +} +``` + +すべての文字列値に対して全文検索ができるので、「`server`」でも +「`example`」でも「`web`」でもヒットします。 + +#### サンプル用テーブル定義とサンプルデータ + +例を示すために使うサンプル用のテーブル定義とサンプルデータを次に示します。 + +```sql +CREATE TABLE logs ( + record jsonb +); + +CREATE INDEX pgroonga_logs_index ON logs USING pgroonga (record); + +INSERT INTO logs + VALUES ('{ + "message": "Server is started.", + "host": "www.example.com", + "tags": [ + "web", + "example.com" + ] + }'); +INSERT INTO logs + VALUES ('{ + "message": "GET /", + "host": "www.example.com", + "code": 200, + "tags": [ + "web", + "example.com" + ] + }'); +INSERT INTO logs + VALUES ('{ + "message": "Send to <info****@examp*****>.", + "host": "mail.example.net", + "tags": [ + "mail", + "example.net" + ] + }'); +``` + +少ないデータでもインデックスを使うようにシーケンシャルスキャンを無効に +します。 + +```sql +SET enable_seqscan = off; +``` + +#### `@>`演算子 + +`@>`演算子は`jsonb`で条件を指定します。カラムの値が条件として指定した +`jsonb`を含んでいればマッチします。 + +マッチする例です。（結果を見やすくするためにPostgreSQL 9.5から使える +`jsonb_pretty()`関数を使っています。） + +```sql +SELECT jsonb_pretty(record) FROM logs WHERE record @> '{"host": "www.example.com"}'::jsonb; +-- jsonb_pretty +-- ------------------------------------- +-- { + +-- "host": "www.example.com", + +-- "tags": [ + +-- "web", + +-- "example.com" + +-- ], + +-- "message": "Server is started."+ +-- } +-- { + +-- "code": 200, + +-- "host": "www.example.com", + +-- "tags": [ + +-- "web", + +-- "example.com" + +-- ], + +-- "message": "GET /" + +-- } +-- (2 rows) +``` + +マッチしない例です。 + +条件の`jsonb`で配列を指定した場合、すべての要素が含まれていればマッチ +します。（配列の要素の順序は関係ありません。）しかし、1つでも含まれて +いない要素があればマッチしません。次の`tags`に`"mail"`を含むレコードも +`"web"`を含むレコードもありますが、両方含むレコードはないのでヒットし +ません。 + +```sql +SELECT jsonb_pretty(record) FROM logs WHERE record @> '{"tags": ["mail", "web"]}'::jsonb; +-- jsonb_pretty +-- -------------- +-- (0 rows) +``` + +#### `@@`演算子 + +`@@`演算子は +[Groongaのスクリプト構文](http://groonga.org/ja/docs/reference/grn_expr/script_syntax.html) +で条件を指定します。条件をどのように指定すればよいかわかるためには、 +PGroongaがどのように`jsonb`のデータに対してインデックスを作成している +かを理解する必要があります。 + +PGroongaは`jsonb`の値を分解し、それぞれの値に対してインデックスを張っ +ています。SQLでいうと次のスキーマがあると考えてください。 + +```sql +CREATE TABLE values ( + key text PRIMARY KEY, + path text, + paths text[], + type text, + boolean boolean, + number double, + string text, + size numeric +); +``` + +それぞれ次の値が入っています。 + + * `key`: 同じ値では同一になる値。フォーマットは「`${パス}|${種類}|${値}`」。条件で使うことはない。 + * `path`: その値の位置を示すルートからのパス。[jq](https://stedolan.github.io/jq/)と互換で、オブジェクトは`["${要素名}"]`、配列は`[]`となる。たとえば、`{"tags": ["web"]}`の`"web"`を示すパスは`.["tags"][]`。パスが完全にわかっている場合は条件でこの値を使う。 + * `paths`: その値の位置を示すパスが複数入っている。絶対パス、サブパス、`.${要素名1}.${要素名2}`表記のパス、配列なしのパスが入っているので条件で指定するときに便利。たとえば、`{"a": {"b": "c": ["x"]}}`の`"x"`の場合は次のパスが入っている。 + * `.a.b.c` + * `.["a"]["b"]["c"]` + * `.["a"]["b"]["c"][]` + * `a.b.c` + * `["a"]["b"]["c"]` + * `["a"]["b"]["c"][]` + * `b.c` + * `["b"]["c"]` + * `["b"]["c"][]` + * `c` + * `["c"]` + * `["c"][]` + * `[]` + * `type`: そのパスの値の種類。種類によって値がどのカラムに入るかが変わる。次のうちのどれか。 + * `object`: オブジェクト。値はない。 + * `array`: 配列。`size`に要素数が入る。 + * `boolean`: 真偽値。`boolean`に値が入る。 + * `number`: 数値。`number`に値が入る。 + * `string`: 文字列。`string`に値が入る。 + * `boolean`: `type`が`boolean`のとき有効な値が入っている。それ以外のときは`false`が入っている。 + * `number`: `type`が`number`のとき有効な値が入っている。それ以外のときは`0`が入っている。 + * `string`: `type`が`string`のとき有効な値が入っている。それ以外のときは空文字列が入っている。 + * `size`: `type`が`array`のとき配列の要素数が入っている。それ以外のときは`0`が入っている。 + +たとえば、次のJSONを考えます。 + +```json +{ + "message": "GET /", + "host": "www.example.com", + "code": 200, + "tags": [ + "web", + "example.com" + ] +} +``` + +このJSONは次のように分解されます。（一部です。） + +| key | path | paths | type | boolean | number | string | size | +| --- | ---- | ----- | ---- | ------- | ------ | ------ | ---- | +| `.|object` | `.` | `[.]` | `object` | | | | | +| `.["message"]|string|GET /` | `.["message"]` | `[.message, .["message"], message, ["message"]]` | `string` | | | `GET /` | | +| `.["tags"][]|string|web` | `.["tags"]` | `[.tags, .["tags"], .["tags"][], tags, ["tags"], ["tags"][], []]` | `string` | | | `web` | | + +`@`演算子の条件では分解した個々の値を特定する条件を指定します。指定した条件すべてを含んだ`jsonb`がマッチした`jsonb`になります。 + +`www.example.com`という文字列を含んだ`jsonb`を検索する場合は次のようにします。 + +```sql +SELECT jsonb_pretty(record) FROM logs WHERE record @@ 'string == "www.example.com"'; +-- jsonb_pretty +-- ------------------------------------- +-- { + +-- "host": "www.example.com", + +-- "tags": [ + +-- "web", + +-- "example.com" + +-- ], + +-- "message": "Server is started."+ +-- } +-- { + +-- "code": 200, + +-- "host": "www.example.com", + +-- "tags": [ + +-- "web", + +-- "example.com" + +-- ], + +-- "message": "GET /" + +-- } +-- (2 rows) +``` + +`code`が`200`台のレコードを検索する場合は次のようにします。省略記法（`.code`）でパスを指定したいので`paths @ "..."`という条件指定をしています。 + +```sql +SELECT jsonb_pretty(record) FROM logs WHERE record @@ 'paths @ ".code" && number >= 200 && number < 300'; +-- jsonb_pretty +-- -------------------------------- +-- { + +-- "code": 200, + +-- "host": "www.example.com",+ +-- "tags": [ + +-- "web", + +-- "example.com" + +-- ], + +-- "message": "GET /" + +-- } +-- (1 row) +``` + +全文検索をする場合は次のように`string @ "..."`を使います。 + +```sql +SELECT jsonb_pretty(record) FROM logs WHERE record @@ 'string @ "started"'; +-- jsonb_pretty +-- ------------------------------------- +-- { + +-- "host": "www.example.com", + +-- "tags": [ + +-- "web", + +-- "example.com" + +-- ], + +-- "message": "Server is started."+ +-- } +-- (1 row) +``` + +クエリー構文（`a OR b`のような書き方）を使って全文検索をしたい場合は +`query("string", "...")`を使います。 + +```sql +SELECT jsonb_pretty(record) FROM logs WHERE record @@ 'query("string", "send OR server")'; +-- jsonb_pretty +-- ---------------------------------------------- +-- { + +-- "host": "www.example.com", + +-- "tags": [ + +-- "web", + +-- "example.com" + +-- ], + +-- "message": "Server is started." + +-- } +-- { + +-- "host": "mail.example.net", + +-- "tags": [ + +-- "mail", + +-- "example.net" + +-- ], + +-- "message": "Send to <info****@examp*****>."+ +-- } +-- (2 rows) +``` + + {: #groonga} ## How to use Groonga throw PGroonga </pre> </td> </tr> </tbody> </table> </div> </body> </html>