Re: Date Iteration

Well...
Something like 'same day next week' (now () + '1 weeks') or 'same date
next month' (now () + '1 months') etc is simple.
Stuff like 'next Monday' is messier - the simplest thing I could think of is

now () + '1 weeks' - (date_part ('dow', now()) || ' days') + '1 days'
::interval (for next Monday for example) or
now () + '1 months' - (date_part ('day', now()) || 'days') + '25
days'::interval (for the 25th next month)

etc.

Something like crond is much better suited for caledars then plain old
sql :-)

Dima

Jake Stride wrote:

>I am currently writing a calendar application and need to figure out on
>which days recurring events occur. I basically have a table with start
>and end dates and a recurrence type (eg/ day/week/month plus a few
>others).
>
>Therefore I would like to be able to work out (for example) the date of
>every monday between the start and end dates or every 25th day of the
>month etc. Is there an (easy) way to do this, or do I need to write a
>function to do it?
>
>Thanks
>
>Jake
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>