Re: Date manipulation

In article <1082322155(dot)6031(dot)3(dot)camel(at)atlas(dot)sol(dot)deeper(dot)co(dot)nz>,
Hadley Willan <hadley(dot)willan(at)deeperdesign(dot)co(dot)nz> writes:

> Hi all,
>     I want to write a function in pgsql that given a number like 7 turns that
> into a date, 7 weeks in the past.  I have a table that is essentially logging
> some information and want to write a trigger that is data driven in trimming
> old values out of the log, that way if I thought that 4 weeks was sufficient,
> I could adjust the value.

Are you absolutely sure you want to do that? This would prune old
log entries on every insert. Why not trimming via crontab?