how to overwrite tuples in a table

From: "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: how to overwrite tuples in a table
Date: 2004-09-09 14:13:50
Message-ID: 77ED2BF75D59D1439F90412CC5B1097411686849@ie10-sahara.hiso.honeywell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I have a table
pointattributes(pointid,attributeid,strvalue,numvalue)......where pointid
and attributeid are foreign keys refering to other tables. Now how can i
overwrite tuples in this table. To make it simpler,
pointid attributeid strvalue numvalue
----------------------------------------------------------------------
4 45 hello 3
7 50 hai 9

I want this table to retain the latest data.....
so if i say insert into pointattributes values(7,50,'Good Morning',10), it
should overwrite the previous tuple with this latest one. Is there a way to
do that.
One simple way is to check if there are any tuples with the given pointid
and attributeid, if a tuple exists delete the tuple with the pointid and
attribute(the combination is unique) and then insert the new tuple.
But is there any better way to do that.

Thanks in advance.

With Best Regards
Pradeep Kumar P J

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2004-09-09 14:24:34 Re: how to overwrite tuples in a table
Previous Message Gaetano Mendola 2004-09-08 23:18:36 Re: Cast