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
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 |