Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group