<!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-12 21:58:02 +0900 (Mon, 12 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/16619ac2218952571f951b909a9dbbe904139275">16619ac2218952571f951b909a9dbbe904139275</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">Update jsonb related ducments.</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/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3">reference/operators/jsonb-contain.md</a></li> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1">reference/operators/jsonb-query.md</a></li> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#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: reference/operators/jsonb-contain.md (+105 -2) =================================================================== </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/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L4">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L7">7</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L8">8</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L9">9</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L10">10</a>                                                                                                                                                                                                 <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L11">11</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L12">12</a>             <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3L16">16</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/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R4">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R8">8</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R9">9</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R10">10</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R11">11</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R12">12</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R16">16</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R17">17</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R18">18</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R19">19</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R20">20</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R21">21</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R26">26</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R30">30</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R31">31</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R32">32</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R33">33</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R34">34</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R66">66</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R67">67</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R68">68</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R72">72</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R75">75</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R76">76</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R77">77</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R78">78</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R79">79</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R80">80</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R81">81</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R82">82</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R83">83</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R84">84</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R85">85</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R87">87</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R88">88</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R90">90</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R93">93</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R96">96</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R97">97</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R98">98</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R99">99</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R100">100</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R101">101</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R102">102</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R103">103</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R104">104</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R105">105</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R106">106</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R107">107</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R108">108</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R109">109</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R110">110</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R111">111</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R112">112</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R113">113</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R114">114</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R115">115</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R116">116</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R117">117</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R118">118</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-166d91108d8e368c718aa0f73b9513f3R119">119</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">@@ -5,12 +5,115 @@ layout: en # `@>` operator +## Summary + PGroonga supports fast index search by `@>` operator. -[`@>` is a built-in PostgreSQL operator](http://www.postgresql.org/docs/current/static/functions-json.html#FUNCTIONS-JSONB-OP-TABLE). `@>` returns true when the right hand side `jsonb` is a sub set of left hand side `jsonb`. +[`@>` is a built-in PostgreSQL operator](http://www.postgresql.org/docs/current/static/functions-json.html#FUNCTIONS-JSONB-OP-TABLE). `@>` returns true when the right hand side `jsonb` is a subset of left hand side `jsonb`. + +## Syntax + +Here is the syntax of this operator: + +```sql +jsonb_column @> jsonb_query +``` + +`jsonb_column` is a column that its type is `jsonb`. + +`jsonb_query` is a `jsonb` value used as query. + +The operator returns `true` when `jsonb_query` is a sub set of `jsonb_column` value, `false` otherwise. + +## Usage + +Here are sample schema and data for examples: + +```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" + ] + }'); +``` + +Disable sequential scan: + +```sql +SET enable_seqscan = off; +``` + +Here is an example for match case: + +(It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) + +```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) +``` + +Here is an example for not match case. + +If you use an array in the condition `jsonb` value, all elements must be included in the search target `jsonb` value. Position of element isn't cared. If there are one or more elements that are included in the condition `jsonb` value but aren't included in the search target `jsonb` value, record that have the search target `jsonb` value isn't matched. + +In the following example, there are records that have only `"mail"` or `"web"` but there are no records that have both `"mail"` and `"web"`. So the following `SELECT` returns no record: -TODO +```sql +SELECT jsonb_pretty(record) FROM logs WHERE record @> '{"tags": ["mail", "web"]}'::jsonb; +-- jsonb_pretty +-- -------------- +-- (0 rows) +``` ## See also * [`jsonb` support](../jsonb.html) + * [`@@` operator](jsonb-query.html) </pre> </td> </tr> </tbody> </table> <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: reference/operators/jsonb-query.md (+224 -2) =================================================================== </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/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1L4">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1L5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1L6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1L7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1L8">8</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1L9">9</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1L10">10</a>                                                                                                                                                                                                                                                                                                                                                                                                                                                             <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1L11">11</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1L12">12</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1L13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1L14">14</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/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R4">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R7">7</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R8">8</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R9">9</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R10">10</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R11">11</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R12">12</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R16">16</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R17">17</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R18">18</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R19">19</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R20">20</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R21">21</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R26">26</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R30">30</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R31">31</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R32">32</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R33">33</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R34">34</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R66">66</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R67">67</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R68">68</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R72">72</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R75">75</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R76">76</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R77">77</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R78">78</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R79">79</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R80">80</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R81">81</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R82">82</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R83">83</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R84">84</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R85">85</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R87">87</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R88">88</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R90">90</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R93">93</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R96">96</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R97">97</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R98">98</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R99">99</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R100">100</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R101">101</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R102">102</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R103">103</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R104">104</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R105">105</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R106">106</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R107">107</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R108">108</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R109">109</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R110">110</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R111">111</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R112">112</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R113">113</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R114">114</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R115">115</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R116">116</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R117">117</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R118">118</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R119">119</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R120">120</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R121">121</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R122">122</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R123">123</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R124">124</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R125">125</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R126">126</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R127">127</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R128">128</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R129">129</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R130">130</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R131">131</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R132">132</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R133">133</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R134">134</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R135">135</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R136">136</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R137">137</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R138">138</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R139">139</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R140">140</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R141">141</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R142">142</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R143">143</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R144">144</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R145">145</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R146">146</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R147">147</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R148">148</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R149">149</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R150">150</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R151">151</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R152">152</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R153">153</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R154">154</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R155">155</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R156">156</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R157">157</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R158">158</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R159">159</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R160">160</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R161">161</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R162">162</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R163">163</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R164">164</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R165">165</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R166">166</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R167">167</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R168">168</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R169">169</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R170">170</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R171">171</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R172">172</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R173">173</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R174">174</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R175">175</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R176">176</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R177">177</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R178">178</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R179">179</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R180">180</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R181">181</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R182">182</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R183">183</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R184">184</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R185">185</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R186">186</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R187">187</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R188">188</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R189">189</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R190">190</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R191">191</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R192">192</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R193">193</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R194">194</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R195">195</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R196">196</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R197">197</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R198">198</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R199">199</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R200">200</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R201">201</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R202">202</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R203">203</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R204">204</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R205">205</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R206">206</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R207">207</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R208">208</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R209">209</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R210">210</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R211">211</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R212">212</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R213">213</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R214">214</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R215">215</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R216">216</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R217">217</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R218">218</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R219">219</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R220">220</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R221">221</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R222">222</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R223">223</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R224">224</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R225">225</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R226">226</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R227">227</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R228">228</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R229">229</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R230">230</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R231">231</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R232">232</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R233">233</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R234">234</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R235">235</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-088b2ac116a7009a9522b48eb4b8f2c1R236">236</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">@@ -5,10 +5,232 @@ layout: en # `@@` operator for `jsonb` type -`@@` operator is a PGroonga original operator. You can use complex condition that can't be written by `@>` operator such as range search. If you know [JsQuery](https://github.com/postgrespro/jsquery), you can understand like "PGroonga provides `jsonb` related search features that are similar to JsQuery with different syntax". +## Summary -TODO +`@@` operator is a PGroonga original operator. You can use complex condition that can't be written by [`@>` operator](jsonb-contain.html) such as range search. + +If you know [JsQuery](https://github.com/postgrespro/jsquery), you can understand like "PGroonga provides `jsonb` related search features that are similar to JsQuery with different syntax". + +## Syntax + +Here is the syntax of this operator: + +```sql +jsonb_column @@ condition +``` + +`jsonb_column` is a column that its type is `jsonb`. + +`condition` is a `text` value used as query. It uses [Groonga's script syntax](http://groonga.org/docs/reference/grn_expr/script_syntax.html). + +The operator returns `true` when `condition` matches `jsonb_column` value, `false` otherwise. + +## Usage + +Here are sample schema and data for examples: + +```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" + ] + }'); +``` + +Disable sequential scan: + +```sql +SET enable_seqscan = off; +``` + +You need to understand how PGroonga creates index against `jsonb` data to create search condition. + +PGroonga splits a `jsonb` value into values and then creates indexes against these values. In SQL, think about the following schema: + +```sql +CREATE TABLE values ( + key text PRIMARY KEY, + path text, + paths text[], + type text, + boolean boolean, + number double precision, + string text, + size numeric +); +``` + +Here are descriptions of column: + + * `key`: The ID of the value. If value has the same path and content, `key` is the same value. Key format is "`${PATH}|${TYPE}|${VALUE}`". It's not used in search condition. + * `path`: The path of the value from root. It uses [jq](https://stedolan.github.io/jq/) compatible format. Object is `["${ELEMENT_NAME}"]`, array is `[]`. For example, the path of `"web"` in `{"tags": ["web"]}` is `.["tags"][]`. If you know absolute path of the value, you can use this value in search condition. + * `paths`: The paths of the value. It includes absolute path, sub paths, `.${ELEMENT_NAME1}.${ELEMENT_NAME2}` format paths, paths without array. This column is convenient for search condition because you can use one of them for search condition. Here are paths for `"x"` in `{"a": {"b": "c": ["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`: The type of the value. This column value is one of them: + * `"object"`: Object. No value. + * `"array"`: Array. The number of elements is stored in `size` column. + * `"boolean"`: Boolean. The value is stored in `boolean` column. + * `"number"`: Number. The value is stored in `number` column. + * `"string"`: String. The value is stored in `string` column. + * `boolean`: The value if `type` column value is `"boolean"`, `false` otherwise. + * `number`: The value if `type` column value is `"number"`, `0` otherwise. + * `string`: The value if `type` column value is `"string"`, `""` otherwise. + * `size`: The number of elements if `type` column value is `"array"`, `0` otherwise. + +Here is a sample JSON: + +```json +{ + "message": "GET /", + "host": "www.example.com", + "code": 200, + "tags": [ + "web", + "example.com" + ] +} +``` + +The JSON is split to the following values. (They are part of all split values.) + +| 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` | | + +You specify condition that matches split value to `@@` operator. If there is one or more values that match specified condition in `jsonb`, the `jsonb` is matched. + +Here is a condition that searches `jsonb` that has `www.example.com` string: + +(It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) + +```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) +``` + +Here is a condition that searches `jsonb` that has number between `200` to `299` as `code` column value. The condition uses `paths @ "..."` syntax to use simple path format (`.code`) to specify path. + +```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) +``` + +Here is a condition for full text search from all text values in `jsonb`: + +```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) +``` + +You can use [Groonga's query syntax](http://groonga.org/docs/reference/grn_expr/query_syntax.html) (`a OR b` can be used) for full text search by `query("string", "...")` syntax: + +```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) +``` ## See also * [`jsonb` support](../jsonb.html) + * [`@>` operator](jsonb-contain.html) </pre> </td> </tr> </tbody> </table> <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 (+17 -153) =================================================================== </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/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL453">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL454">454</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL455">455</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL456">456</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL457">457</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL458">458</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL459">459</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL460">460</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL461">461</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL462">462</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL463">463</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL464">464</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL510">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL511">511</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL512">512</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL513">513</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL514">514</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL515">515</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL516">516</a>       <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL517">517</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL518">518</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL519">519</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL538">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL539">539</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL540">540</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL541">541</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL542">542</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL543">543</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL544">544</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL545">545</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL546">546</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL547">547</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL548">548</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL549">549</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL550">550</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL551">551</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL552">552</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL553">553</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL554">554</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL555">555</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL556">556</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL557">557</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL558">558</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL559">559</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL560">560</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL561">561</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL562">562</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL563">563</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL564">564</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL565">565</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL566">566</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL567">567</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL568">568</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL569">569</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL570">570</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL571">571</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL572">572</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL573">573</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL574">574</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL575">575</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL576">576</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL577">577</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL578">578</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL579">579</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL580">580</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL581">581</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL582">582</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL583">583</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL584">584</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL585">585</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL586">586</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL587">587</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL588">588</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL589">589</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL590">590</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL591">591</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL592">592</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL593">593</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL594">594</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL595">595</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL596">596</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL597">597</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL598">598</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL599">599</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL600">600</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL601">601</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL602">602</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL603">603</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL604">604</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL605">605</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL606">606</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL607">607</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL608">608</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL609">609</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL610">610</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL611">611</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL612">612</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL613">613</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL614">614</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL615">615</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL616">616</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL617">617</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL618">618</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL619">619</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL620">620</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL621">621</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL622">622</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL623">623</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL624">624</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL625">625</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL626">626</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL627">627</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL628">628</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL629">629</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL630">630</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL631">631</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL632">632</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL633">633</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL634">634</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL635">635</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL636">636</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL637">637</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL638">638</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL639">639</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL640">640</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL641">641</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL642">642</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL643">643</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL644">644</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL645">645</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL646">646</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL647">647</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL648">648</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL649">649</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL650">650</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL651">651</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL652">652</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL653">653</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL654">654</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL655">655</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL656">656</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL657">657</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL658">658</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL669">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL670">670</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL671">671</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL672">672</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL673">673</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL674">674</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL675">675</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL676">676</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL677">677</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL678">678</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL679">679</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL680">680</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL681">681</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL682">682</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL683">683</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL684">684</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL685">685</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL686">686</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL687">687</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL688">688</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL689">689</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL690">690</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL691">691</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL692">692</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL693">693</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL694">694</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL695">695</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL696">696</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL697">697</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL698">698</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL699">699</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL700">700</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL701">701</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL702">702</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL703">703</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL704">704</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL705">705</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL706">706</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL707">707</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL708">708</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL709">709</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL710">710</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL711">711</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL712">712</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL713">713</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL714">714</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL715">715</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL716">716</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL717">717</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL788">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL789">789</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL790">790</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dL791">791</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/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR453">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR454">454</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR455">455</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR456">456</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR457">457</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR458">458</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR459">459</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR460">460</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR461">461</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR462">462</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR463">463</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR464">464</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR510">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR511">511</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR512">512</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR513">513</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR514">514</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR515">515</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR516">516</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR517">517</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR518">518</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR519">519</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR520">520</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR521">521</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR540">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR541">541</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR542">542</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR543">543</a>                           <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR544">544</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR545">545</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR546">546</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR547">547</a>                                                                                                                           <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR548">548</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR549">549</a>           <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR550">550</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR551">551</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR552">552</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR553">553</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR554">554</a>                                                       <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR555">555</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR556">556</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR557">557</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR558">558</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR569">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR570">570</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR571">571</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR572">572</a>                                                                                     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR573">573</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR574">574</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR575">575</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR646">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR647">647</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR648">648</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR649">649</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR650">650</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR651">651</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR652">652</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR653">653</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR654">654</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/16619ac2218952571f951b909a9dbbe904139275#diff-9962a6ea2afe8b6ff739a66ee41a6d1dR655">655</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">@@ -454,11 +454,11 @@ PGroonga provides the following two operators for searching against `jsonb`: * `@>` operator * `@@` operator -[`@>` operator is a built-in PostgreSQL operator](http://www.postgresql.org/docs/current/static/functions-json.html#FUNCTIONS-JSONB-OP-TABLE). `@>` returns true when the right hand side `jsonb` is a sub set of left hand side `jsonb`. +[`@>` operator is a built-in PostgreSQL operator](http://www.postgresql.org/docs/current/static/functions-json.html#FUNCTIONS-JSONB-OP-TABLE). `@>` returns true when the right hand side `jsonb` is a subset of left hand side `jsonb`. You can execute `@>` faster by PGroonga. -`@@` operator is a PGroonga original operator. You can use complex condition that can't be written by `@>` operator such as range search. If you know [JsQuery](https://github.com/postgrespro/jsquery), you can understand like "PGroonga provides `jsonb` related search features that are similar to JsQuery with different syntax". +`@@` operator is a PGroonga original operator. You can use complex condition that can't be written by `@>` operator such as range search. ### Sample schema and data @@ -511,9 +511,11 @@ SET enable_seqscan = off; ### `@>` operator -`@>` operator specify search condition by `jsonb` value. If search target `jsonb` value contains the condition `jsonb` value, record that have the search target `jsonb` is matched. +`@>` operator specify search condition by `jsonb` value. If condition `jsonb` value is a subset of the search target `jsonb` value, `@>` operator returns `true`. -Here is an example for match case. (It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) +Here is an example: + +(It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) ```sql SELECT jsonb_pretty(record) FROM logs WHERE record @> '{"host": "www.example.com"}'::jsonb; @@ -539,120 +541,18 @@ SELECT jsonb_pretty(record) FROM logs WHERE record @> '{"host": "www.example.com -- (2 rows) ``` -Here is an example for not match case. - -If you use an array in the condition `jsonb` value, all elements must be included in the search target `jsonb` value. Position of element isn't cared. If there are one or more elements that are included in the condition `jsonb` value but aren't included in the search target `jsonb` value, record that have the search target `jsonb` value isn't matched. - -In the following example, there are records that have only `"mail"` or `"web"` but there are no records that have both `"mail"` and `"web"`. So the following `SELECT` returns no record: - -```sql -SELECT jsonb_pretty(record) FROM logs WHERE record @> '{"tags": ["mail", "web"]}'::jsonb; --- jsonb_pretty --- -------------- --- (0 rows) -``` - See [`@>` operator](../reference/operators/jsonb-contain.html) for more details. ### `@@` operator -`@@` operator uses [Groonga's script syntax](http://groonga.org/docs/reference/grn_expr/script_syntax.html) for specifying search condition. You need to understand how PGroonga creates index against `jsonb` data to create search condition. - -PGroonga splits a `jsonb` value into values and then creates indexes against these values. In SQL, think about the following schema: - -```sql -CREATE TABLE values ( - key text PRIMARY KEY, - path text, - paths text[], - type text, - boolean boolean, - number double precision, - string text, - size numeric -); -``` - -Here are descriptions of column: - - * `key`: The ID of the value. If value has the same path and content, `key` is the same value. Key format is "`${PATH}|${TYPE}|${VALUE}`". It's not used in search condition. - * `path`: The path of the value from root. It uses [jq](https://stedolan.github.io/jq/) compatible format. Object is `["${ELEMENT_NAME}"]`, array is `[]`. For example, the path of `"web"` in `{"tags": ["web"]}` is `.["tags"][]`. If you know absolute path of the value, you can use this value in search condition. - * `paths`: The paths of the value. It includes absolute path, sub paths, `.${ELEMENT_NAME1}.${ELEMENT_NAME2}` format paths, paths without array. This column is convenient for search condition because you can use one of them for search condition. Here are paths for `"x"` in `{"a": {"b": "c": ["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`: The type of the value. This column value is one of them: - * `"object"`: Object. No value. - * `"array"`: Array. The number of elements is stored in `size` column. - * `"boolean"`: Boolean. The value is stored in `boolean` column. - * `"number"`: Number. The value is stored in `number` column. - * `"string"`: String. The value is stored in `string` column. - * `boolean`: The value if `type` column value is `"boolean"`, `false` otherwise. - * `number`: The value if `type` column value is `"number"`, `0` otherwise. - * `string`: The value if `type` column value is `"string"`, `""` otherwise. - * `size`: The number of elements if `type` column value is `"array"`, `0` otherwise. - -Here is a sample JSON: - -```json -{ - "message": "GET /", - "host": "www.example.com", - "code": 200, - "tags": [ - "web", - "example.com" - ] -} -``` - -The JSON is split to the following values. (They are part of all split values.) +`@@` operator is a PGroonga original operator. You can write complex condition that can't be written by `@>` operator such as range search. -| 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` | | +Here is an example for range search. The `SELECT` returns records that is matched with the following conditions: -You specify condition that matches split value to `@@` operator. If there is one or more values that match specified condition in `jsonb`, the `jsonb` is matched. + * `code` key exists at the top-level object + * Value of the `code` is greater than or equal to `200` and less than `300` -Here is a condition that searches `jsonb` that has `www.example.com` string: - -```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) -``` - -Here is a condition that searches `jsonb` that has number between `200` to `299` as `code` column value. The condition uses `paths @ "..."` syntax to use simple path format (`.code`) to specify path. +(It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) ```sql SELECT jsonb_pretty(record) FROM logs WHERE record @@ 'paths @ ".code" && number >= 200 && number < 300'; @@ -670,48 +570,6 @@ SELECT jsonb_pretty(record) FROM logs WHERE record @@ 'paths @ ".code" && number -- (1 row) ``` -Here is a condition for full text search from all text values in `jsonb`: - -```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) -``` - -You can use [Groonga's query syntax](http://groonga.org/docs/reference/grn_expr/query_syntax.html) (`a OR b` can be used) for full text search by `query("string", "...")` syntax: - -```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) -``` - See [`@@` operator for `jsonb`](../reference/operators/jsonb-query.html) for more details. {: #groonga} @@ -789,3 +647,9 @@ SELECT * ``` See [`pgroonga.table_name` function](../reference/functions/pgroonga-table-name.html) for more details. + +## Next step + +Now, you knew all PGroonga features! If you want to understand each feature, see [reference](../reference/) manual for each feature. + +If you get a problem or want to share your useful information, please contact [PGroonga community](../community/). </pre> </td> </tr> </tbody> </table> </div> </body> </html>