Re: Could be improved point of UPSERT

Поиск
Список
Период
Сортировка
Искать
От
Peter Geoghegan
Тема
Re: Could be improved point of UPSERT
Дата
Msg-id
CAM3SWZR+5xmsbQAL9F3AxCDtCmuAGOqev9a1ouaBUEyPAe6SDA@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Could be improved point of UPSERT Yourfriend <doudou586@gmail.com>
Re: Could be improved point of UPSERT Peter Geoghegan <pg@heroku.com>
Re: Could be improved point of UPSERT Gianni <nasus.maximos@gmail.com>
Re: Could be improved point of UPSERT Peter Geoghegan <pg@heroku.com>
Re: Could be improved point of UPSERT Yourfriend <doudou586@gmail.com>
Re: Could be improved point of UPSERT Peter Geoghegan <pg@heroku.com>
Re: Could be improved point of UPSERT Yourfriend <doudou586@gmail.com>
On Tue, Jul 14, 2015 at 11:40 AM, Gianni  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
Дата:
От: Alvaro Herrera
Дата:
FAQ