Update
Example
Initial state: Following the (non-query) inserts from before:
select * from T;
k | x | y | z
---+----+-----+---------------
1 | 10 | 111 | hello
2 | | 0 |
3 | 30 | 0 |
4 | 40 | 444 | for four fore
5 | 50 | 555 | make
6 | 60 | 666 | america
7 | 70 | 777 | irate
8 | 80 | 888 | again
(8 rows)
Add 1000 to y in rows for which x < 50.
update T
set y = y + 1000
where x < 50
UPDATE 3
|