Register now or log in to join your professional community.
Use the alternative column-list syntax to do update. for Example:
UPDATE weather SET (temp_lo, temp_hi, prcp) = (temp_lo+1, temp_lo+15, DEFAULT)
WHERE city = 'Baghdad' AND date = '2003-07-03';