Does update = delete + insert ?

Поиск
Список
Период
Сортировка
От Gauthier, Dave
Тема Does update = delete + insert ?
Дата
Msg-id 482E80323A35A54498B8B70FF2B879800458C31048@azsmsx504.amr.corp.intel.com
обсуждение исходный текст
Ответы Re: Does update = delete + insert ?  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Does update = delete + insert ?  (Steve Atkins <steve@blighty.com>)
Список 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 по дате отправления:

Предыдущее
От: paladine
Дата:
Сообщение: Re: reducing postgresql disk space
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Does update = delete + insert ?