Re: Calculating repeating events - functionality lost with the demise of tinterval ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel <psql-novice(at)netzach(dot)co(dot)il>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Calculating repeating events - functionality lost with the demise of tinterval ?
Date: 2008-07-02 17:01:59
Message-ID: 13182.1215018119@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alan Hodgson 2008-07-02 17:02:48 Re: Concurrent COPY commands
Previous Message Stephan Szabo 2008-07-02 17:00:51 Re: encoding problem when creating a database