Date Iteration

From: Jake Stride <nsuk(at)users(dot)sourceforge(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Date Iteration
Date: 2003-07-09 07:56:06
Message-ID: 1057737366.1056.7.camel@tintagel.senokian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-07-09 12:23:06 Re: Date Iteration
Previous Message HK 2003-07-09 06:10:24 Dont allow updation for few columns in a record.