Problem with UPDATE query - Mailing list pgsql-novice

From Johan Daine
Subject Problem with UPDATE query
Date
Msg-id 3A833444.1DD45DB5@chello.be
Whole thread Raw
Responses Re: Problem with UPDATE query  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
List pgsql-novice
How can I update several columns in one UPDATE query ?
The users's guide says:

UPDATE table SET col = expression [, ...]
    [ FROM fromlist ]
    [ WHERE condition ]

But this is what I get:

jd=> CREATE TABLE foo (v1 INT2, v2 INT2, v3 INT2 );
CREATE
jd=> insert into foo values(1,2,3);
INSERT 22187 1
jd=> UPDATE foo SET v2=3 , SET v3=4 WHERE v1=1 ;
ERROR:  parser: parse error at or near "v3"
jd=>

Thanks

--
           _/    /_/_/_/            Johan Daine
          _/    /_/    _/           mailto:isis@wanadoo.be
         _/    /_/    _/            http://web.wanadoo.be/isis.w
        _/    /_/    _/
       _/    /_/    _/
 /_/_/_/    /_/_/_/



pgsql-novice by date:

Previous
From: Etienne De Kerckhove
Date:
Subject: UPDATES
Next
From: "Raymond Golish"
Date:
Subject: arrays of compound types