Hello. I have a table that contains time stamped data. To delete rows
that are over 90 days old, I do this:
DELETE FROM ONLY richtable WHERE trxdate < current_timestamp - interval
'90 days';
This works great. But I was wondering if there is a better or more
compact way to go about it. (this method feels "clunky" to me)
Thanks.
-Kyle