Replacing old tuples on insert - Mailing list pgsql-novice

From Pradeepkumar, Pyatalo (IE10)
Subject Replacing old tuples on insert
Date
Msg-id 77ED2BF75D59D1439F90412CC5B1097414FC98AE@ie10-sahara.hiso.honeywell.com
Whole thread Raw
Responses Re: Replacing old tuples on insert  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice

Hi all,

I have a table as follows -
table TrendData( TrendID bigserial,
                 TrendName varchar(30),
                 .....
                 .....);

Now for this table i want a maximum of only 5000 tuples. After the maximum
is reached the new tuples that are inserted should replace the older ones.
Could anyone help me out in writing the query or a trigger would also be
fine.

Thanx and Regards,
Pradeep

pgsql-novice by date:

Previous
From: "Pradeepkumar, Pyatalo (IE10)"
Date:
Subject: Replacing old tuples on insert
Next
From: "Jeff Flowers"
Date:
Subject: Multi-Row Inserts And Blobs