Best way to delete time stamped data? - Mailing list pgsql-sql

From Kyle
Subject Best way to delete time stamped data?
Date
Msg-id 3EB2EBF0.8010003@ccidomain.com
Whole thread Raw
Responses Re: Best way to delete time stamped data?  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Best way to delete time stamped data?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: "Katka a Daniel Dunajsky"
Date:
Subject: How to increase precision?
Next
From: Steve Crawford
Date:
Subject: Re: How to increase precision?