Best way to delete time stamped data?

From: Kyle <kyle(at)ccidomain(dot)com>
To: Forum - PostGreSQL SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Best way to delete time stamped data?
Date: 2003-05-02 22:06:40
Message-ID: 3EB2EBF0.8010003@ccidomain.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2003-05-02 22:07:55 Re: connect problems
Previous Message elein 2003-05-02 21:56:39 Re: Postgres client/server parameters?

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Crawford 2003-05-02 22:13:31 Re: How to increase precision?
Previous Message Katka a Daniel Dunajsky 2003-05-02 21:38:21 How to increase precision?