<!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-24 14:23:19 +0900 (Sat, 24 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/823db74babbbce0fe90f5258a876220c9ba93fe7">823db74babbbce0fe90f5258a876220c9ba93fe7</a></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt> <dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">Translate jsonb</pre></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Added files</dt> <dd style="margin-left: 8.5em"> <ul> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672">_po/ja/reference/jsonb.po</a></li> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91e">ja/reference/jsonb.md</a></li> </ul> </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/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214">ja/tutorial/index.md</a></li> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-0440c0aca3db2d643afbb5341d67f2ce">reference/jsonb.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"> Added: _po/ja/reference/jsonb.po (+99 -0) 100644 =================================================================== </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/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672">...</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/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R1">1</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R2">2</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R3">3</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R4">4</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R8">8</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R9">9</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R10">10</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R11">11</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R12">12</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R16">16</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R17">17</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R18">18</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R19">19</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R20">20</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R21">21</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R26">26</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R30">30</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R31">31</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R32">32</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R33">33</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R34">34</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R66">66</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R67">67</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R68">68</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R72">72</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R75">75</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R76">76</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R77">77</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R78">78</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R79">79</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R80">80</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R81">81</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R82">82</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R83">83</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R84">84</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R85">85</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R87">87</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R88">88</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R90">90</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R93">93</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R96">96</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R97">97</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R98">98</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-73b91d0450629ce4b80c0ae5dca90672R99">99</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">@@ -0,0 +1,99 @@ +msgid "" +msgstr "" +"Project-Id-Version: PACKAGE VERSION\n" +"PO-Revision-Date: 2015-10-24 11:05+0900\n" +"Language: ja\n" +"MIME-Version: 1.0\n" +"Content-Type: text/plain; charset=UTF-8\n" +"Content-Transfer-Encoding: 8bit\n" +"Plural-Forms: nplurals=1; plural=0;\n" + +msgid "" +"---\n" +"title: jsonb support\n" +"layout: en\n" +"---" +msgstr "" +"---\n" +"title: jsonbサポート\n" +"layout: ja\n" +"---" + +msgid "# `jsonb` support" +msgstr "# `jsonb`サポート" + +msgid "" +"PGroonga also supports `jsonb` type. You can search JSON data by one or more k" +"eys and/or one or more values with PGroonga." +msgstr "PGroongaは`jsonb`型もサポートしています。PGroongaを使うと複数のキー・値に対して条件を指定してJSONデータを検索できます。" + +msgid "" +"You can also search JSON data by full text search against all text values in J" +"SON. It's an unique feature of PGroonga. Built-in PostgreSQL features and [JsQ" +"uery](https://github.com/postgrespro/jsquery) don't support it." +msgstr "" +"JSON内のすべてのテキスト値に対して全文検索をしてJSONデータを検索することもできます。これはPostgreSQL組み込みの機能でも[JsQuery](" +"https://github.com/postgrespro/jsquery)でもサポートしていない機能です。" + +msgid "Think about the following JSON:" +msgstr "次のようなJSONを考えてください。" + +msgid "" +"```json\n" +"{\n" +" \"message\": \"Server is started.\",\n" +" \"host\": \"www.example.com\",\n" +" \"tags\": [\n" +" \"web\",\n" +" ]\n" +"}\n" +"```" +msgstr "" + +msgid "" +"You can find the JSON by full text search with `search`, `example` or `web` be" +"cause all text values are full text search target." +msgstr "" +"`search`でも`example`でも`web`でもどの単語で全文検索してもこのJSONを検索することができます。なぜなら、すべてのテキスト値が全文検索" +"対象だからです。" + +msgid "## Operators" +msgstr "## 演算子" + +msgid "PGroonga provides the following two operators for searching against `jsonb`:" +msgstr "PGroongaは`jsonb`型の値で検索するために次の2つの演算子を提供しています。" + +msgid "" +" * [`@>` operator](operators/jsonb-contain.html)\n" +" * [`@@` operator](operators/jsonb-query.html)" +msgstr "" +" * [`@>`演算子](operators/jsonb-contain.html)\n" +" * [`@@`演算子](operators/jsonb-query.html)" + +msgid "" +"`@>` operator is simpler than `@@` operator but you can't use complex conditio" +"n such as range search." +msgstr "`@>`演算子は`@@`演算子よりもシンプルですが範囲検索のような複雑な条件を指定することはできません。" + +msgid "" +"`@@` operator is more complex than `@>` operator but you can use complex condi" +"tion. You can also use full text search against all text values in JSON." +msgstr "`@@`演算子は`@>`演算子より複雑ですが、複雑な条件も使えます。JSON内のすべてのテキスト値に対する全文検索もできます。" + +msgid "## Comparison with GIN" +msgstr "## GINとの比較" + +msgid "PostgreSQL provides built-in fast `jsonb` search feature by GIN." +msgstr "PostgreSQLは組み込みの機能としてGINを使った高速な`jsonb`検索機能を提供しています。" + +msgid "Here are differences between PGroonga and GIN:" +msgstr "PGroongaとGINの違いは次の通りです。" + +msgid "" +" * Index creation time: No difference\n" +" * Search time: PGroonga is a bit faster\n" +" * Features: PGroonga provides more search features" +msgstr "" +" * インデックス作成時間：ほぼ同じ\n" +" * 検索時間：PGroongaの方が少し速い\n" +" * 機能：PGroongaの方がより多くの検索機能を提供" </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"> Added: ja/reference/jsonb.md (+45 -0) 100644 =================================================================== </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/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91e">...</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/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91e">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR1">1</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR2">2</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR3">3</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR4">4</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR8">8</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR9">9</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR10">10</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR11">11</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR12">12</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR16">16</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR17">17</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR18">18</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR19">19</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR20">20</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR21">21</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR26">26</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR30">30</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR31">31</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR32">32</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR33">33</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR34">34</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-98c2de039ca127cb310ae80f773ce91eR45">45</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">@@ -0,0 +1,45 @@ +--- +title: jsonbサポート +layout: ja +--- + +# `jsonb`サポート + +PGroongaは`jsonb`型もサポートしています。PGroongaを使うと複数のキー・値に対して条件を指定してJSONデータを検索できます。 + +JSON内のすべてのテキスト値に対して全文検索をしてJSONデータを検索することもできます。これはPostgreSQL組み込みの機能でも[JsQuery](https://github.com/postgrespro/jsquery)でもサポートしていない機能です。 + +次のようなJSONを考えてください。 + +```json +{ + "message": "Server is started.", + "host": "www.example.com", + "tags": [ + "web", + ] +} +``` + +`search`でも`example`でも`web`でもどの単語で全文検索してもこのJSONを検索することができます。なぜなら、すべてのテキスト値が全文検索対象だからです。 + +## 演算子 + +PGroongaは`jsonb`型の値で検索するために次の2つの演算子を提供しています。 + + * [`@>`演算子](operators/jsonb-contain.html) + * [`@@`演算子](operators/jsonb-query.html) + +`@>`演算子は`@@`演算子よりもシンプルですが範囲検索のような複雑な条件を指定することはできません。 + +`@@`演算子は`@>`演算子より複雑ですが、複雑な条件も使えます。JSON内のすべてのテキスト値に対する全文検索もできます。 + +## GINとの比較 + +PostgreSQLは組み込みの機能としてGINを使った高速な`jsonb`検索機能を提供しています。 + +PGroongaとGINの違いは次の通りです。 + + * インデックス作成時間：ほぼ同じ + * 検索時間：PGroongaの方が少し速い + * 機能：PGroongaの方がより多くの検索機能を提供 </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: ja/tutorial/index.md (+5 -5) =================================================================== </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/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L432">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L433">433</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L434">434</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L435">435</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L436">436</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L437">437</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L438">438</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L439">439</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L440">440</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L441">441</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L442">442</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L443">443</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L448">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L449">449</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L450">450</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L451">451</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L452">452</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L453">453</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L454">454</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L455">455</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L456">456</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214L457">457</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/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R432">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R433">433</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R434">434</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R435">435</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R436">436</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R437">437</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R438">438</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R439">439</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R440">440</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R441">441</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R442">442</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R443">443</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R448">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R449">449</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R450">450</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R451">451</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R452">452</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R453">453</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R454">454</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R455">455</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R456">456</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-78fbd18ca5b3a5aa6768a8beec1b7214R457">457</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">@@ -433,11 +433,11 @@ SELECT * FROM products WHERE tags %% 'PostgreSQL'; ## JSONに対してPGroongaを使う方法 -PGroongaは`jsonb`型にも対応しています。PGroongaを使うとJSON中のキー・値に対して検索することができます。 +PGroongaは`jsonb`型もサポートしています。PGroongaを使うと複数のキー・値に対して条件を指定してJSONデータを検索できます。 -JSON中のすべてのテキスト値に対して全文検索することもできます。これはPGroonga独自の機能です。PostgreSQL組み込みの機能でも[JsQuery](https://github.com/postgrespro/jsquery)でもこの機能はサポートしていません。 +JSON内のすべてのテキスト値に対して全文検索をしてJSONデータを検索することもできます。これはPostgreSQL組み込みの機能でも[JsQuery](https://github.com/postgrespro/jsquery)でもサポートしていない機能です。 -次のJSONを考えてください。 +次のようなJSONを考えてください。 ```json { @@ -449,9 +449,9 @@ JSON中のすべてのテキスト値に対して全文検索することもで } ``` -`search`、`example`、`web`のどれで全文検索してもこのJSONを見つけることができます。なぜなら、すべてのテキスト値が全文検索対象だからです。 +`search`でも`example`でも`web`でもどの単語で全文検索してもこのJSONを検索することができます。なぜなら、すべてのテキスト値が全文検索対象だからです。 -PGroongaは`jsonb`に対して検索するために次の2つの演算子を提供しています。 +PGroongaは`jsonb`型の値で検索するために次の2つの演算子を提供しています。 * `@>`演算子 * `@@`演算子 </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/jsonb.md (+1 -0) =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-0440c0aca3db2d643afbb5341d67f2ceL41">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-0440c0aca3db2d643afbb5341d67f2ceL42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-0440c0aca3db2d643afbb5341d67f2ceL43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-0440c0aca3db2d643afbb5341d67f2ceL44">44</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/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-0440c0aca3db2d643afbb5341d67f2ceR41">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-0440c0aca3db2d643afbb5341d67f2ceR42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-0440c0aca3db2d643afbb5341d67f2ceR43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-0440c0aca3db2d643afbb5341d67f2ceR44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/823db74babbbce0fe90f5258a876220c9ba93fe7#diff-0440c0aca3db2d643afbb5341d67f2ceR45">45</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">@@ -42,3 +42,4 @@ Here are differences between PGroonga and GIN: * Index creation time: No difference * Search time: PGroonga is a bit faster + * Features: PGroonga provides more search features </pre> </td> </tr> </tbody> </table> </div> </body> </html>