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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: UPDATE sql question

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.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly