Best way to delete time stamped data?

Поиск
Список
Период
Сортировка
От Kyle
Тема Best way to delete time stamped data?
Дата
Msg-id 3EB2EBF0.8010003@ccidomain.com
обсуждение исходный текст
Ответы Re: Best way to delete time stamped data?
Re: Best way to delete time stamped data?
Список 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 по дате отправления:

Предыдущее
От: "Katka a Daniel Dunajsky"
Дата:
Сообщение: How to increase precision?
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: How to increase precision?