Re: Limit record count - Mailing list pgsql-general

From Rodrigo Gonzalez
Subject Re: Limit record count
Date
Msg-id 4766F72C.5040002@gmail.com
Whole thread Raw
In response to Limit record count  ("Sean Z." <sean09182006@yahoo.com>)
List pgsql-general
DELETE FROM <table> WHERE <id> NOT IN (SELECT <id> FROM <table> ORDER BY
<id> DESC LIMIT 50)

Sean Z. escribió:
> 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.
> <http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>



Attachment

pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: spreadsheet interface
Next
From: Greg Smith
Date:
Subject: Re: install problem