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(at)wanadoo(dot)be
_/ /_/ _/ http://web.wanadoo.be/isis.w
_/ /_/ _/
_/ /_/ _/
/_/_/_/ /_/_/_/