<!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 16:25:15 +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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0">0bfa49518b148c1a2adf5292b6b0f0882a31e7d0</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 pgroonga.score</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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33">_po/ja/reference/functions/pgroonga-score.po</a></li> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25d">ja/reference/functions/pgroonga-score.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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91e">ja/reference/jsonb.md</a></li> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214">ja/tutorial/index.md</a></li> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648">reference/functions/pgroonga-score.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/functions/pgroonga-score.po (+133 -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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33">...</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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R1">1</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R2">2</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R3">3</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R4">4</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R8">8</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R9">9</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R10">10</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R11">11</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R12">12</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R16">16</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R17">17</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R18">18</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R19">19</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R20">20</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R21">21</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R26">26</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R30">30</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R31">31</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R32">32</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R33">33</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R34">34</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R66">66</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R67">67</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R68">68</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R72">72</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R75">75</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R76">76</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R77">77</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R78">78</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R79">79</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R80">80</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R81">81</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R82">82</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R83">83</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R84">84</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R85">85</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R87">87</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R88">88</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R90">90</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R93">93</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R96">96</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R97">97</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R98">98</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R99">99</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R100">100</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R101">101</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R102">102</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R103">103</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R104">104</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R105">105</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R106">106</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R107">107</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R108">108</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R109">109</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R110">110</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R111">111</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R112">112</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R113">113</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R114">114</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R115">115</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R116">116</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R117">117</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R118">118</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R119">119</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R120">120</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R121">121</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R122">122</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R123">123</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R124">124</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R125">125</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R126">126</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R127">127</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R128">128</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R129">129</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R130">130</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R131">131</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R132">132</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-a0015d9e057d16f3f3746ea2d8aa2b33R133">133</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,133 @@ +msgid "" +msgstr "" +"Project-Id-Version: PACKAGE VERSION\n" +"PO-Revision-Date: 2015-10-24 16:24+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: pgroonga.score function\n" +"layout: en\n" +"---" +msgstr "" +"---\n" +"title: pgroonga.score関数\n" +"layout: ja\n" +"---" + +msgid "# `pgroonga.score` function" +msgstr "# `pgroonga.score`関数" + +msgid "## Summary" +msgstr "## 概要" + +msgid "" +"`pgroonga.score` function returns precision as a number. If a record is more p" +"recision against searched query, the record has more higher number." +msgstr "" +"`pgroonga.score`関数はマッチした度合いを数値で返します。もし、検索したクエリーに対してそのレコードがマッチしているほどそのレコードのスコアー" +"は高い数値になります。" + +msgid "## Syntax" +msgstr "## 構文" + +msgid "" +"You can use `pgroonga.score` function to get precision as a number. If a recor" +"d is more precision against searched query, the record has more higher number." +msgstr "" +"`pgroonga.score`関数を使うとマッチした度合いを数値で取得することができます。検索したクエリーに対してよりマッチしているレコードほど高い数値に" +"なります。" + +msgid "" +"```text\n" +"double precision pgroonga.score(record)\n" +"```" +msgstr "" + +msgid "`record` is a table name." +msgstr "`record`はテーブル名です。" + +msgid "Assume that you have the following schema:" +msgstr "次のスキーマが定義されているとします。" + +msgid "" +"```sql\n" +"CREATE TABLE score_memos (\n" +" id integer PRIMARY KEY,\n" +" content text\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_score_memos_content_index\n" +" ON score_memos\n" +" USING pgroonga (id, content);\n" +"```" +msgstr "" + +msgid "`record` must be `score_memos`:" +msgstr "`record`は`score_memos`にします。" + +msgid "" +"```sql\n" +"SELECT *, pgroonga.score(score_memos)\n" +" FROM score_memos\n" +" WHERE content %% 'PGroonga';\n" +"```" +msgstr "" + +msgid "`pgroonga.score` function return precision as `double precision` type value." +msgstr "`pgroonga.score`関数は`double precision`型の値でマッチした度合いを返します。" + +msgid "## Usage" +msgstr "## 使い方" + +msgid "" +"You need to add primary key column into `pgroonga` index to use `pgroonga.scor" +"e` function. If you don't add primary key column into `pgroonga` index, `pgroo" +"nga.score` function always returns `0.0`." +msgstr "" +"`pgroonga.score`関数を使うには、`pgroonga`インデックスにプライマリーキーに指定したカラムを追加する必要があります。もし、プライマリ" +"ーキーに指定したカラムを`pgroonga`インデックスに追加していない場合は、`pgroonga.score`関数は常に`0.0`を返します。" + +msgid "" +"`pgroonga.score` function always returns `0.0` when full text search isn't per" +"formed by index. In other words, `pgroonga.score` function always returns `0.0" +"` when full text search is performed by sequential scan." +msgstr "" +"`pgroonga.score`関数はインデックスを使わずに全文検索した場合は常に`0.0`を返します。言い換えると、`pgroonga.score`関数は" +"シーケンシャルスキャンで全文検索を実行した場合は常に`0.0`を返します。" + +msgid "" +"If `pgroonga.score` function returns `0.0` unexpectedly, confirm the following" +"s:" +msgstr "もし、`pgroonga.score`関数が意図せずに`0.0`を返しているときは、次のことを確認してください。" + +msgid "" +" * Whether the column that is specified as primary key is included in index t" +"argets of the PGroonga index or not\n" +" * Whether the full text search is performed by index or not" +msgstr "" +" * プライマリーキーに指定しているカラムがPGroongaのインデックス対象に含まれているかどうか\n" +" * インデックスを使って全文検索されているかどうか" + +msgid "" +"Score is \"how many keywords are included\" (TF, Term Frequency) for now. Groong" +"a supports customizing how to score. But PGroonga doesn't support yet it for n" +"ow." +msgstr "" +"現在のところ、スコアーの値は「何個キーワードが含まれていたか」（TF、Term Frequency）です。Groongaはどのようにスコアーを計算するかをカ" +"スタマイズすることができます。しかし、PGroongaはまだその機能をサポートしていません。" + +msgid "See [examples in tutorial](../../tutorial/#score)." +msgstr "[チュートリアルの中の例](../../tutorial/#score)を参考にしてください。" + +msgid "## See also" +msgstr "## 参考" + +msgid " * [Examples in tutorial](../../tutorial/#score)" +msgstr " * [チュートリアルの中の例](../../tutorial/#score)" </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/functions/pgroonga-score.md (+64 -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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25d">...</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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25d">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR1">1</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR2">2</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR3">3</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR4">4</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR8">8</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR9">9</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR10">10</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR11">11</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR12">12</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR16">16</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR17">17</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR18">18</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR19">19</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR20">20</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR21">21</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR26">26</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR30">30</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR31">31</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR32">32</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR33">33</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR34">34</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-45695fa427d1eb8c7bad191c5cd7d25dR64">64</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,64 @@ +--- +title: pgroonga.score関数 +layout: ja +--- + +# `pgroonga.score`関数 + +## 概要 + +`pgroonga.score`関数はマッチした度合いを数値で返します。もし、検索したクエリーに対してそのレコードがマッチしているほどそのレコードのスコアーは高い数値になります。 + +## 構文 + +`pgroonga.score`関数を使うとマッチした度合いを数値で取得することができます。検索したクエリーに対してよりマッチしているレコードほど高い数値になります。 + +```text +double precision pgroonga.score(record) +``` + +`record`はテーブル名です。 + +次のスキーマが定義されているとします。 + +```sql +CREATE TABLE score_memos ( + id integer PRIMARY KEY, + content text +); + +CREATE INDEX pgroonga_score_memos_content_index + ON score_memos + USING pgroonga (id, content); +``` + +`record`は`score_memos`にします。 + +```sql +SELECT *, pgroonga.score(score_memos) + FROM score_memos + WHERE content %% 'PGroonga'; +``` + +`pgroonga.score`関数は`double precision`型の値でマッチした度合いを返します。 + +## 使い方 + +`pgroonga.score`関数を使うには、`pgroonga`インデックスにプライマリーキーに指定したカラムを追加する必要があります。もし、プライマリーキーに指定したカラムを`pgroonga`インデックスに追加していない場合は、`pgroonga.score`関数は常に`0.0`を返します。 + +`pgroonga.score`関数はインデックスを使わずに全文検索した場合は常に`0.0`を返します。言い換えると、`pgroonga.score`関数はシーケンシャルスキャンで全文検索を実行した場合は常に`0.0`を返します。 + +もし、`pgroonga.score`関数が意図せずに`0.0`を返しているときは、次のことを確認してください。 + + * プライマリーキーに指定しているカラムがPGroongaのインデックス対象に含まれているかどうか + * インデックスを使って全文検索されているかどうか + +現在のところ、スコアーの値は「何個キーワードが含まれていたか」（TF、Term Frequency）です。Groongaはどのようにスコアーを計算するかをカスタマイズすることができます。しかし、PGroongaはまだその機能をサポートしていません。 + +## 使い方 + +[チュートリアルの中の例](../../tutorial/#score)を参考にしてください。 + +## 参考 + + * [チュートリアルの中の例](../../tutorial/#score) </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/reference/jsonb.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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL4">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL8">8</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL9">9</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL10">10</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL11">11</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL12">12</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL20">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL21">21</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL24">24</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL26">26</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL28">28</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL30">30</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eL31">31</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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR4">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR7">7</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR8">8</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR9">9</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR10">10</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR11">11</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR12">12</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR20">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR21">21</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR23">23</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR26">26</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR27">27</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR30">30</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-98c2de039ca127cb310ae80f773ce91eR31">31</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,11 +5,11 @@ layout: ja # `jsonb`サポート -PGroongaは`jsonb`型もサポートしています。PGroongaを使うと複数のキー・値に対して条件を指定してJSONデータを検索できます。 +PGroongaは`jsonb`型にも対応しています。PGroongaを使うとJSON中のキー・値に対して検索することができます。 -JSON内のすべてのテキスト値に対して全文検索をしてJSONデータを検索することもできます。これはPostgreSQL組み込みの機能でも[JsQuery](https://github.com/postgrespro/jsquery)でもサポートしていない機能です。 +JSON中のすべてのテキスト値に対して全文検索することもできます。これはPGroonga独自の機能です。PostgreSQL組み込みの機能でも[JsQuery](https://github.com/postgrespro/jsquery)でもこの機能はサポートしていません。 -次のようなJSONを考えてください。 +次のJSONを考えてください。 ```json { @@ -21,11 +21,11 @@ JSON内のすべてのテキスト値に対して全文検索をしてJSONデー } ``` -`search`でも`example`でも`web`でもどの単語で全文検索してもこのJSONを検索することができます。なぜなら、すべてのテキスト値が全文検索対象だからです。 +`search`、`example`、`web`のどれで全文検索してもこのJSONを見つけることができます。なぜなら、すべてのテキスト値が全文検索対象だからです。 ## 演算子 -PGroongaは`jsonb`型の値で検索するために次の2つの演算子を提供しています。 +PGroongaは`jsonb`に対して検索するために次の2つの演算子を提供しています。 * [`@>`演算子](operators/jsonb-contain.html) * [`@@`演算子](operators/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: 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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L432">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L433">433</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L434">434</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L435">435</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L436">436</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L437">437</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L438">438</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L439">439</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L440">440</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L441">441</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L442">442</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L443">443</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L448">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L449">449</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L450">450</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L451">451</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L452">452</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L453">453</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L454">454</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L455">455</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214L456">456</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R432">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R433">433</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R434">434</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R435">435</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R436">436</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R437">437</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R438">438</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R439">439</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R440">440</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R441">441</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R442">442</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R443">443</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R448">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R449">449</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R450">450</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R451">451</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R452">452</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R453">453</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R454">454</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R455">455</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-78fbd18ca5b3a5aa6768a8beec1b7214R456">456</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#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内のすべてのテキスト値に対して全文検索をしてJSONデータを検索することもできます。これはPostgreSQL組み込みの機能でも[JsQuery](https://github.com/postgrespro/jsquery)でもサポートしていない機能です。 +JSON中のすべてのテキスト値に対して全文検索することもできます。これはPGroonga独自の機能です。PostgreSQL組み込みの機能でも[JsQuery](https://github.com/postgrespro/jsquery)でもこの機能はサポートしていません。 -次のようなJSONを考えてください。 +次のJSONを考えてください。 ```json { @@ -449,9 +449,9 @@ JSON内のすべてのテキスト値に対して全文検索をして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/functions/pgroonga-score.md (+1 -1) =================================================================== </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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648L45">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648L46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648L47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648L48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648L49">49</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648L50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648L51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648L52">52</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/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648R45">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648R46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648R47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648R48">48</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648R49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648R50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648R51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/0bfa49518b148c1a2adf5292b6b0f0882a31e7d0#diff-f944870684f320ab2c18c786c615b648R52">52</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">@@ -46,7 +46,7 @@ SELECT *, pgroonga.score(score_memos) You need to add primary key column into `pgroonga` index to use `pgroonga.score` function. If you don't add primary key column into `pgroonga` index, `pgroonga.score` function always returns `0.0`. -`pgroonga.score` function always returns `0.0` when full text search isn't performed by index. In other words, `pgroonga.score` function always returns `0` when full text search is performed by sequential scan. +`pgroonga.score` function always returns `0.0` when full text search isn't performed by index. In other words, `pgroonga.score` function always returns `0.0` when full text search is performed by sequential scan. If `pgroonga.score` function returns `0.0` unexpectedly, confirm the followings: </pre> </td> </tr> </tbody> </table> </div> </body> </html>