In article <1082322155.6031.3.camel@atlas.sol.deeper.co.nz>,
Hadley Willan <hadley.willan@deeperdesign.co.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?