Daniel <psql-novice@[EMAIL PROTECTED]
> 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
--
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
|
