word: two-letter language codes

[sheet.git] / tools / mkwordlist

diff --git a/tools/mkwordlist b/tools/mkwordlist
index bec1362b51b2c6a39cd94a2c75912ca1dc73f48f..5e965fed73c4894740d12fb4f4a849756171f8d8 100755 (executable)
--- a/tools/mkwordlist
+++ b/tools/mkwordlist
@@ -1,8 +1,4 @@
 #!/bin/sh
 psql sheet -XAt -c "
-       SELECT json_object_agg(coalesce(form, ''), forms)
-               FROM word RIGHT JOIN (
-                       SELECT cat id, array_agg(form ORDER BY form) forms
-                               FROM word WHERE ref IS NULL GROUP BY cat
-               ) sub USING (id)
-" | sed 's/:/=>/g'
+       SELECT json_object_agg(coalesce(form, ''), forms) FROM _cat_words
+" | sed 's/ : / => /g'