UPDATE sql question
UPDATE sql question
От:
Andrei Verovski (aka MacGuru) <andreil1@mail.starlett.lv>
Дата:
Hi, What exactly will happen if UPDATE sql statement instructs to update some columns with the same values as already in the database? Will Postgres update only different values or it will simply modify all columns listed in UPDATE sql? Thanks in advance for any suggestion. ********************************************* * Best Regards --- Andrei Verovski * * Personal Home Page * http://snow.prohosting.com/guru4mac * Mac, Linux, DTP, Development, IT WEB Site *********************************************
Re: UPDATE sql question
От:
"scott.marlowe" <scott.marlowe@ihs.com>
Дата:
On Mon, 28 Jul 2003, Andrei Verovski wrote: > Hi, > > What exactly will happen if UPDATE sql statement instructs to update > some columns with the same values as already in the database? Will > Postgres update only different values or it will simply modify all > columns listed in UPDATE sql? It will update the columns. Which means lots of dead tuples, which means vacuuming.