This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
version, or one of the supported versions listed above instead.
||Chapter 13. The
You can update existing instances using the update command.
Suppose you discover the temperature readings are all off by 2
degrees as of Nov 28, you may update the data as follow:
SET temp_hi = temp_hi - 2, temp_lo = temp_lo - 2
WHERE date > '11/28/1994';