Does update = delete + insert ? - Mailing list pgsql-general

From Gauthier, Dave
Subject Does update = delete + insert ?
Date
Msg-id 482E80323A35A54498B8B70FF2B879800458C31048@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: Does update = delete + insert ?  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Does update = delete + insert ?  (Steve Atkins <steve@blighty.com>)
List 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 !

pgsql-general by date:

Previous
From: paladine
Date:
Subject: Re: reducing postgresql disk space
Next
From: Andreas Kretschmer
Date:
Subject: Re: Does update = delete + insert ?