This page in other versions: Unsupported versions: 6.3
PostgreSQL
Prev Chapter 13. The Query Language Next

Updates

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:

UPDATE weather
    SET temp_hi = temp_hi - 2,  temp_lo = temp_lo - 2
    WHERE date > '11/28/1994';

Prev Home Next
Joins Between Classes Up Deletions
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group