On Sat, Nov 4, 2017 at 6:41 PM, Marc-Olaf Jaschke <moj(at)dshare(dot)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