Re: Could be improved point of UPSERT

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Could be improved point of UPSERT
Дата
Msg-id CAM3SWZR+5xmsbQAL9F3AxCDtCmuAGOqev9a1ouaBUEyPAe6SDA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Could be improved point of UPSERT  (Gianni <nasus.maximos@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Tue, Jul 14, 2015 at 11:40 AM, Gianni <nasus.maximos@gmail.com> wrote:
> Could there be a version of UPSERT where an update is tried, and if 0 records
> are modified, an insert is done?
>
> Just wondering, I haven't got am use-case for that.  I don't mid gaps in
> sequences.

Perhaps, if you don't mind having a severely restricted set of
qualifications in the UPDATE, which the existing command effectively
has anyway. That would be a very odd thing.

-- 
Peter Geoghegan

В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Guimaraes
Дата:
Сообщение: Re: Forensic recovery deleted pgdump custom format file
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: ctidscan as an example of custom-scan (Re: [v9.5] Custom Plan API)