On Sat, Nov 4, 2017 at 6:41 PM, Marc-Olaf Jaschke <moj@dshare.de> wrote:
Perhaps I misunderstand the discussion but would "INSERT .. ON CONFLICT DO SELECT [FOR ..]" not provide a solution for the following use case?
[ .. ]
That works. But it is a bit inconvenient to write the pseudo update clause.
Right. This is exactly the use case for ON CONFLICT DO SELECT. The "no-op" UPDATE bloats the table unnecessary and just generally results in unnecessary overhead.
.m
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.