Kouhei Sutou
null+****@clear*****
Thu Jun 9 15:21:45 JST 2016
Kouhei Sutou 2016-06-09 15:21:45 +0900 (Thu, 09 Jun 2016) New Revision: 7e38b82b0b1d2ad74144dfc11959e54e7d7cb607 https://github.com/pgroonga/pgroonga/commit/7e38b82b0b1d2ad74144dfc11959e54e7d7cb607 Message: example completion: sort result Modified files: examples/completion/complete.sh Modified: examples/completion/complete.sh (+5 -2) =================================================================== --- examples/completion/complete.sh 2016-06-09 15:13:29 +0900 (2aa4dc4) +++ examples/completion/complete.sh 2016-06-09 15:21:45 +0900 (a940523) @@ -9,9 +9,12 @@ fi input=$1 cat <<SQL -SET enable_seqscan = no; +-- SET enable_seqscan = no; +-- EXPLAIN ANALYZE VERBOSE SELECT term, readings, english FROM dictionary WHERE term &^ '$1' OR - readings &^~> '$1'; + readings &^~> '$1' + ORDER BY term + LIMIT 10; SQL -------------- next part -------------- HTML����������������������������...ダウンロード
