It's that time of the bi-month again ...

In honor of day 3 of this year's Haru Basho in Osaka and the kind services of Masumi Abe who compiled the data ... I've written some XEmacs Lisp that takes the "Machine-readable" Sumo statistics on http://www.scgroup.com/sumo/format.html and puts it into a Postgres database. Put the attached two files somewhere in .xemacs/xemacs-packages/lisp, download the data files somewhere, (require 'pg-sumodb) and M-x pg-sumodb-load and follow the prompts. Tested against Postgres 6.5.3 and 7.0beta, XEmacs 21.1/21.2. If XEmacs chokes, be sure you're running with the most recent set of postgres patches (i.e. from about 7 hours ago). Sample query: SELECT count (*), k.reading as "Kimarite" FROM all_results ar, kimarite k WHERE ar.kimarite=k.number AND ar.rikishi='Musashimaru' AND result = 1 GROUP BY k.reading ORDER BY count DESC; count | Kimarite ------+----------------- 108 | Yorikiri 107 | Oshidashi 24 | Oshitaoshi 18 | Yoritaoshi ...