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.
I've had a quick look around the docs and they're fairly spartan on details like this.
Can anybody point me to an online reference for pgsql overall and something that talks about the pitfalls and gives code examples of this kind of thing?