"which views contain a row that intersects with today?"
You could use a structure like:
create view year_month as select n, 'dt_year' as tbl_name from dt_year union select n, 'dt_month' as tbl_name from dt_month;
n | tbl_name ---------------------+---------- 1970-01-01 00:00:00 | dt_month 1970-01-01 00:00:00 | dt_year 1970-02-01 00:00:00 | dt_month 1970-03-01 00:00:00 | dt_month 1970-04-01 00:00:00 | dt_month ...
However, I don't know if you can modify a view to add or remove recurrences (is it possible?).
Here's my way of doing it.
I guess I agree with you: http://www.nntp.perl.org/group/perl.datetime/5749
- Flavio S. Glock