Thread: UPDATE sql question

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
*********************************************

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.