<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-2022-jp">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"$B#M#S(B $B%4%7%C%/(B";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:"\@$B#M#S(B $B%4%7%C%/(B";
panose-1:2 11 6 9 7 2 5 8 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0mm;
margin-bottom:.0001pt;
text-align:justify;
text-justify:inter-ideograph;
font-size:10.5pt;
font-family:"Arial",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"$B=q<0$J$7(B \($BJ8;z(B\)";
margin:0mm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"$B#M#S(B $B%4%7%C%/(B";}
span.a
{mso-style-name:"$B=q<0$J$7(B \($BJ8;z(B\)";
mso-style-priority:99;
mso-style-link:$B=q<0$J$7(B;
font-family:"$B#M#S(B $B%4%7%C%/(B";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Arial",sans-serif;}
/* Page Definitions */
@page WordSection1
{size:612.0pt 792.0pt;
margin:99.25pt 30.0mm 30.0mm 30.0mm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026">
<v:textbox inset="5.85pt,.7pt,5.85pt,.7pt" />
</o:shapedefaults></xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="JA" link="#0563C1" vlink="#954F72" style="text-justify-trim:punctuation">
<div class="WordSection1">
<p class="MsoPlainText">$B?\F#MM(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B$*@$OC$K$J$C$F$*$j$^$9!#:4F#$G$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B$42sEz$"$j$,$H$&$4$6$$$^$7$?!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText">$B@55,2=$O<B;\$7$?$$$?$a!"(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US" style="color:#2F5597;mso-style-textfill-fill-color:#2F5597;mso-style-textfill-fill-alpha:100.0%">></span><span style="color:#2F5597;mso-style-textfill-fill-color:#2F5597;mso-style-textfill-fill-alpha:100.0%">$B@55,2=$O$7$?$$!"$H$$$&>l9g$NJL0F$O!"<!$N%j%j!<%9$GF~$kM=Dj$N(B<span lang="EN-US"><o:p></o:p></span></span></p>
<p class="MsoPlainText"><span lang="EN-US" style="color:#2F5597;mso-style-textfill-fill-color:#2F5597;mso-style-textfill-fill-alpha:100.0%">>pgroonga_normalize()</span><span style="color:#2F5597;mso-style-textfill-fill-color:#2F5597;mso-style-textfill-fill-alpha:100.0%">$B4X?t$rAH$_9g$o$;$k$H$$$&$b$N$,$"$j$^$9!#(B<span lang="EN-US"><o:p></o:p></span></span></p>
<p class="MsoPlainText">$B$3$N2sEzDL$j!"$3$N4X?t$N;EMM$r8!F$$7$F$h$&$H;W$$$^$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B$3$NEY$O$"$j$,$H$&$4$6$$$^$7$?!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText">$B$^$?$h$m$7$/$*4j$$$$$?$7$^$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">-----Original Message-----<br>
From: groon****@lists***** [mailto:groon****@lists*****] On Behalf Of Kouhei Sutou<br>
Sent: Wednesday, December 20, 2017 11:19 AM<br>
To: groon****@lists*****<br>
Subject: [groonga-dev,04557] Re: </span>$B1i;;;R(B<span lang="EN-US">&@~ </span>$B;HMQ;~$N(B<span lang="EN-US">""</span>$BFb$N%9%Z!<%9$N5sF0$K$D$$$F(B</p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B?\F#$G$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">In <<a href="mailto:03295****@MP-MS*****"><span style="color:windowtext;text-decoration:none">03295****@MP-MS*****</span></a>><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> "[groonga-dev,04556] </span>$B1i;;;R(B<span lang="EN-US">&@~
</span>$B;HMQ;~$N(B<span lang="EN-US">""</span>$BFb$N%9%Z!<%9$N5sF0$K$D$$$F(B<span lang="EN-US">" on Tue, 19 Dec 2017 06:28:20 +0000,<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> <<a href="mailto:satou****@nttda*****"><span style="color:windowtext;text-decoration:none">satou****@nttda*****</span></a>> wrote:<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> </span>$B8!:wMQ(B<span lang="EN-US">SQL</span>$B$G$O!"(B<span lang="EN-US">"te st"</span>$B$r$7$F$$$k$?$a!"(B<span lang="EN-US">te</span>$B$H(B<span lang="EN-US">st</span>$B$N4V$KH>3Q%9%Z!<%9$,F~$C$F$$$k$b$N$N$_$,;XDj$5$l$k$3$H$r4|BT$7$F$$$^$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> </span>$B$7$+$7!"7k2L$OH>3Q%9%Z!<%9$,F~$C$F$$$J$$$b$N!J(B<span lang="EN-US">test.xlsx</span>$B!K$b%R%C%H$7$F$$$^$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> </span>$B$3$l$O!";EMM$J$N$G$7$g$&$+!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B$O$$!";EMM$G$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText">$B!V(B<span lang="EN-US">&@~ '"te st"'</span>$B!W$O%U%l!<%:8!:w$J$N$G$9$,!"$3$N%U%l!<%:8!:w(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText">$B$O!V(B<span lang="EN-US">te</span>$B!W$N$"$H$KO"B3$7$F!V(B<span lang="EN-US">st</span>$B!W$,=P8=$9$k!"$H$$$&0UL#$K$J$j$^(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText">$B$9!#H>3Q%9%Z!<%9$b4^$s$G!V(B<span lang="EN-US">te st</span>$B!W$,=P8=$9$k!"$H$$$&0UL#$G$O(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText">$B$J$$$N$G$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B4|BT$9$k5sF0$K$9$kJ}K!$G$9$,!"(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">CREATE INDEX xxx<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> ON sample.sample<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> USING pgroonga(file_name)<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> WITH (tokenizer='TokenBigramSplitSymbolAlphaDigit',<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> normalizer='none');<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B$H$$$&$h$&$K(B<span lang="EN-US">normalizer='none'</span>$B$r;XDj$7$F$/$@$5$$!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText">$B$3$l$G!"J8;z$N@55,2=5!G=$,L58z$K$J$j!"%H!<%/%J%$%6!<$,H>3Q%9(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText">$B%Z!<%9$rG'<1$G$-$J$/$J$k$N$G!"H>3Q%9%Z!<%9$bB>$NJ8;z$HF1$807(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText">$B$$$K$J$j$^$9!#$D$^$j!"H>3Q%9%Z!<%9$b4^$s$G!V(B<span lang="EN-US">te st</span>$B!W$r8!:w$9(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText">$B$k$3$H$K$J$j$^$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B$?$@!"@55,2=5!G=$,L58z$K$J$k$N$G!"!V(B<span lang="EN-US">Te st</span>$B!W$N$h$&$KBgJ8;z>.(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText">$BJ8;z$,0c$&$H%R%C%H$7$J$/$J$j$^$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B@55,2=$O$7$?$$!"$H$$$&>l9g$NJL0F$O!"<!$N%j%j!<%9$GF~$kM=Dj$N(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">pgroonga_normalize()</span>$B4X?t$rAH$_9g$o$;$k$H$$$&$b$N$,$"$j$^$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">CREATE INDEX xxx<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> ON sample.sample<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> USING pgroonga(pgroonga_normalize(file_name))<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> WITH (tokenizer='TokenBigramSplitSymbolAlphaDigit',<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> normalizer='none');<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B$H$7$F!"(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">select * from sample.sample<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> where pgroonga_normalize(file_name) &@~(('"te st"'))<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B$H8!:w$7$^$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B$3$l$G!V(B<span lang="EN-US">Te st</span>$B!W$G$b%R%C%H$7$^$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">-- <o:p></o:p></span></p>
<p class="MsoPlainText">$B?\F#(B $B8yJ?(B<span lang="EN-US"> <<a href="mailto:kou****@clear*****"><span style="color:windowtext;text-decoration:none">kou****@clear*****</span></a>><o:p></o:p></span></p>
<p class="MsoPlainText">$B3t<02q<R%/%j%"%3!<%I(B<span lang="EN-US"> <<a href="http://www.clear-code.com/"><span style="color:windowtext;text-decoration:none">http://www.clear-code.com/</span></a>><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">Groonga</span>$B%Y!<%9$NA4J88!:w%7%9%F%`$rAm9g%5%]!<%H!'(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> <a href="http://groonga.org/ja/support/">
<span style="color:windowtext;text-decoration:none">http://groonga.org/ja/support/</span></a><o:p></o:p></span></p>
<p class="MsoPlainText">$B%Q%C%A:NMQ(B<span lang="EN-US"> - </span>$B%W%m%0%i%_%s%0$,3Z$7$$?M8~$1$N:NMQ%W%m%;%9!'(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> <a href="http://www.clear-code.com/recruitment/">
<span style="color:windowtext;text-decoration:none">http://www.clear-code.com/recruitment/</span></a><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">OSS</span>$B3+H/;Y1g%5!<%S%9(B<span lang="EN-US">:<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> <a href="http://www.clear-code.com/blog/2016/6/27.html">
<span style="color:windowtext;text-decoration:none">http://www.clear-code.com/blog/2016/6/27.html</span></a><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">_______________________________________________<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">groonga-dev mailing list<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><a href="mailto:groon****@lists*****"><span style="color:windowtext;text-decoration:none">groon****@lists*****</span></a><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><a href="https://lists.osdn.me/mailman/listinfo/groonga-dev"><span style="color:windowtext;text-decoration:none">https://lists.osdn.me/mailman/listinfo/groonga-dev</span></a><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
</body>
</html>