Home > mailing lists

Limit record count - Mailing list pgsql-general

From	Sean Z.
Subject	Limit record count
Date	December 17, 2007 21:03:09
Msg-id	229478.80511.qm@web45105.mail.sp1.yahoo.com Whole thread Raw
Responses	Re: Limit record count
List	pgsql-general

Tree view

Hi,

I need to write a maintenance function to delete oldest records of a table, leaving only a certain number of records, say 50. The task should run once per day. How can I write it?
The oldest record carries the smallest ID.

Thanks a lot!
Sean

Never miss a thing. Make Yahoo your homepage.

pgsql-general by date:

From: "Joshua D. Drake"
Date: 17 December 2007, 20:59:07
Subject: Re: install problem

From: "Dave Page"
Date: 17 December 2007, 21:22:59
Subject: Re: spreadsheet interface

Limit record count - Mailing list pgsql-general

Previous

Next