On Sat, Nov 4, 2017 at 6:41 PM, Marc-Olaf Jaschke <m...@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