Daniel <psql-novice(at)netzach(dot)co(dot)il> writes:
>> If that doesn't satisfy your requirements, you need to be more clear
>> about what they are.
> Apologies for the lack of clarity.
> Try repeat_frequency='1 month'
Ah. Well, with something like that, you really can't speak in terms of
modulo, because months aren't all the same length. I'd be inclined to
solve this with a small plpgsql function, along the lines of
curdate := start_date;
while curdate < test_date loop
curdate := curdate + repeat_interval;
end loop;
return (curdate = test_date);
Kinda grotty but there probably isn't any cleaner solution that really
works for arbitrary intervals.
regards, tom lane