How can I update several columns in one UPDATE query ?
The users's guide says:
UPDATE table SET col = expression [, ...]
[ FROM fromlist ]
[ WHERE condition ]
CREATE TABLE time(
orderdate date,
day char(10),
month char(10),
year integer
);
UPDATE timed SET month='january' where month='1' and set month='feb' where month = '2';
ERROR: parser: parse error at or near "month"
thanks
sudharshan
--
Sudharshan Reddy G
Masters of Computer Science,
Victoria University Of Willington,
Willington-6004
NewZealand