tak_kaz24****@yahoo*****
tak_kaz24****@yahoo*****
2016年 10月 19日 (水) 14:18:44 JST
$B?\F#MM!#9b66$G$9!#2sEz$"$j$,$H$&$4$6$$$^$9!#(B $B%a%b%j%j!<%/$N2DG=@-$,9b$$;]>5CN$7$^$7$?!#(B $B:F8=<j=g$H$7$F$O0J2<$N$h$&$K$J$j$^$9!#(B $B-!(BCREATE SCHEMA SCHEMA_NAME;$B$G%9%-!<%^:n ＠ .(B $B-"O"7H$7$?%F!<%V%kDj5A$G(BCREATE TABLE;$B$G%F!<%V%k:n ＠ .(B $B-#0J2<$G%$%s%G%C%/%9$r:n ＠ .(B CREATE INDEX CO_DOCUMENT_DATA_PGR_IDX ON SCHEMA_NAME.CONTENT USING pgroonga(DOCUMENT_DATA); CREATE INDEX CO_SCORE_PGR_IDX ON SCHEMA_NAME.CONTENT USING pgroonga(COLUMN1, DOCUMENT_DATA); $B-$(BCOPY ...; $B"((BCOPY$B%3%^%s%I$G%F!<%V%kDj5A$KBP1~$7$?0J2<$N$h$&$J(Bdat$B%U%!%$%k$r(BPostgreSQL$B$K%m!<%I$7$F$$$^$9!#(B $B<g%-!<(BCOLUMN1$B$O%*!<%H%J%s%P!<$N$?$a$=$l0J30$rDj5A$7$F$$$^$9(B URL $B%U%!%$%kL>(B $B%U%!%$%k<oJL(B $B%j%S%8%g%sHV9f(B $BG/7nF|(B $B%P!<%8%g%sHV9f(B $BF|K\8l%I%-%e%a%s%H(B $B-%(BSELECT COLUMN1, pgroonga.score(CONTENT) AS SCORE_POINT FROM SCHEMA_NAME.CONTENT WHERE DOCUMENT_DATA @@ #SearchKeyword# ORDER BY SCORE_POINT DESC; $B"(F1$8(BSQL$B$rJ#?t2sB3$1$F<B;\$9$k$HH/@8$7$^$9!#(BHeap$B$N%5%$%:$,$=$NETEYA}2C$7$F$$$-$^$9(B $B<B%G!<%?$K4X$7$F$O@)8B$,$"$j$^$9$N$GDs6!$O$G$-$^$;$s!#(B $B0J2<$N$h$&$JE@$KN10U$$$?$@$1$l$P62$i$/F1Ey$N%G!<%?$O:n ＠ .$G$-$k$H;W$$$^$9$N$G!"(B $B62$lF~$j$^$9$,0lC6$3$NFbMF$G:F8=$G$-$k$+3NG'$$$?$@$1$^$9$G$7$g$&$+!#(B $B!&%G!<%?$N7o?t$O(B1$BK|7oDxEY(B $B!&(BCOLUMN2$B!A(BCOLUMN7$B$O(BURL$B$d%U%!%$%kL>Ey$J$N$GB?$/$F$b(B100$B%P%$%HDxEY(B $B!&(BDOCUMENT_DATA$B$OF|K\8l%G!<%?$GBg$-$$%G!<%?$G(B100KB$BDxEY(B $B$h$m$7$/$*4j$$$7$^$9!#(B
