Re: Update problem.

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" <ajs(at)crankycanuck(dot)ca>
To: <pgsql-sql(at)postgresql(dot)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 | ajs(at)crankycanuck(dot)ca
> 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