postgresql Update all rows meeting a condition


Example

UPDATE person SET state = 'NY' WHERE city = 'New York';