Обсуждение: Problem with UPDATE query

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

On Thu, 8 Feb 2001, Johan Daine wrote:

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

UPDATE foo SET v2=3, v3=4 WHERE v1 = 1;

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
"The only way for a reporter to look at a politician is down."
-- H.L. Mencken