Re: Problem with UPDATE query

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