Thanks. But to do the UPDATE i have to write each column name (for recrd 4)
and with its column name (for record 2) which is quite alot to write :P
UPDATE MOD48_00_2007 SET te_cognome= te_cognome, te_paternita= te_paternita
WHERE N_GEN= 9
so it will be like that? But i have to set each column name = to the column
name.
And i have to do it for echt field? isn't there any other way..
"I hate writting :P"
And Andrew can explain a bit the setval()
Thanks
Shavonne Wijesinghe
From: "Andrew Sullivan" <[EMAIL PROTECTED]>
To: <pgsql-sql@postgresql.org>
Sent: Monday, April 02, 2007 5:17 PM
Subject: Re: [SQL] Update problem.
On Mon, Apr 02, 2007 at 04:52:46PM +0200, Shavonne Marietta Wijesinghe
wrote:
At a surtain point i need to replace a record with another
For example i have inserted 4 records. (1, 2 , 3 , 4) I need to
replace all the values from the record 4 to the record 2 but
keeping the n_gen serial key. And then delete the record 4. So that
the next record i insert will take the n_gen 4
If I understand you correclty, you can do an UPDATE to record 4 to
record 2, then do a setval() on the sequence. The setval() is
tricky, though, because you have the problem that other connections
could be using it. I'd lock the table in question while you did all
this.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Unfortunately reformatting the Internet is a little more painful
than reformatting your hard drive when it gets out of whack.
--Scott Morris
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
