Search Postgresql Archives

Limit record count

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux