Does update = delete + insert ?

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Does update = delete + insert ?
Date: 2010-05-26 18:41:16
Message-ID: 482E80323A35A54498B8B70FF2B879800458C31048@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:

Under the hood, does PG implement an update statement as a delete followed by an insert? I'm at a point in coding a script where it would be more expeditious for me to delete/insert a record as opposed to update and want to know if I lose anything by doing that.

Thanks in Advance !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2010-05-26 18:50:16 Re: Does update = delete + insert ?
Previous Message paladine 2010-05-26 16:13:31 Re: reducing postgresql disk space