loader/sql/materialize_all_months.sql


1
2
3
4
5
6
7
8
9
10

\set ON_ERROR_STOP
BEGIN;

TRUNCATE TABLE list_months;

INSERT INTO list_months(listid, year, month)
SELECT DISTINCT listid, EXTRACT(year FROM date), EXTRACT(month FROM date)
FROM messages INNER JOIN list_threads ON messages.threadid=list_threads.threadid;

COMMIT;