Postgres 9.3: How to update row that has max value of a timestamp in addition to other selection criteria?
UPDATE appointments SET recurring = 0 
WHERE id = 433 
AND time = (select max(time) from appointments where id = 433);


... is the answer. You just needed brackets.