word: select mkwordlist forms from _cat_words view

[sheet.git] / tools / mkwordlist

diff --git a/tools/mkwordlist b/tools/mkwordlist
index bec1362b51b2c6a39cd94a2c75912ca1dc73f48f..d4dfaa245cf8e28e563b4bc4c47f9ca64aefdecd 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)
+       SELECT json_object_agg(coalesce(form, ''), forms) FROM _cat_words
 " | sed 's/:/=>/g'