Replacing old tuples on insert

From: "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Replacing old tuples on insert
Date: 2004-11-24 09:20:42
Message-ID: 77ED2BF75D59D1439F90412CC5B1097414FC98AE@ie10-sahara.hiso.honeywell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jeff Flowers 2004-11-24 14:55:20 Multi-Row Inserts And Blobs
Previous Message Pradeepkumar, Pyatalo (IE10) 2004-11-24 09:09:10 Replacing old tuples on insert