update problem - Mailing list pgsql-novice

From Sudharshan Reddy
Subject update problem
Date
Msg-id 200209091355.35282.Sudharshan.Gundlapalle@mcs.vuw.ac.nz
Whole thread Raw
Responses Re: update problem
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 ]

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

pgsql-novice by date:

Previous
From: "torres monta±es manuel eduardo"
Date:
Subject: Kdevelop and libpq++
Next
From: Oliver Elphick
Date:
Subject: Re: update problem