Skip site navigation (1) Skip section navigation (2)

Re: UPDATE sql question

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Andrei Verovski <andreil1(at)mail(dot)starlett(dot)lv>
Cc: <pgsql-php(at)postgresql(dot)org>
Subject: Re: UPDATE sql question
Date: 2003-07-28 18:16:12
Message-ID: Pine.LNX.4.33.0307281215490.19755-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-php
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.


In response to

pgsql-php by date

Next:From: Andrei Verovski (aka MacGuru)Date: 2003-07-29 14:55:46
Subject: Strange problem starting PostgreSQL
Previous:From: Josh BerkusDate: 2003-07-28 17:11:31
Subject: Re: Accessing Postgres db from apache using PHP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group