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:09:10
Message-ID: 77ED2BF75D59D1439F90412CC5B1097414FB13D1@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

Browse pgsql-novice by date

  From Date Subject
Next Message Pradeepkumar, Pyatalo (IE10) 2004-11-24 09:20:42 Replacing old tuples on insert
Previous Message Kjetil Haaland 2004-11-24 09:05:47 Re: memory allocation in postgres