Re: Best way to delete time stamped data?
От
Bruno Wolff III
Тема
Re: Best way to delete time stamped data?
Дата
Msg-id
20030505133222.GA2981@wolff.to
Ответ на
Re: Best way to delete time stamped data? (Rajesh Kumar Mallah)
Список
Дерево обсуждения
Best way to delete time stamped data? Kyle <kyle@ccidomain.com>
Re: Best way to delete time stamped data? Josh Berkus <josh@agliodbs.com>
Re: Best way to delete time stamped data? Rajesh Kumar Mallah <mallah@trade-india.com>
Re: Best way to delete time stamped data? Bruno Wolff III <bruno@wolff.to>
Re: Best way to delete time stamped data? Steve Crawford <scrawford@pinpointresearch.com>
On Mon, May 05, 2003 at 15:26:21 +0530, Rajesh Kumar Mallah wrote: > > > an index on age(date(trxdate)) would make it faster ? That won't work because the value returned by age depends on the time the transaction started. If you want the delete to be indexed you need to write it out the longer way.
В списке pgsql-sql по дате отправления
