Hi all
Is it possible to have ON CONFLICT DO NOTHING RETURNING or must I use DO
UPDATE?
E.g. if the 'name' column of my 'animals' table is unique it seems a little
silly having to do an arbitrary update to get an ID from the row:
INSERT INTO animals (name) VALUES ('dog') ON CONFLICT (name) DO UPDATE SET
name='dog' RETURNING animal_id;
Is there a reason DO NOTHING was not developed for use with RETURNING?
Either way, upsert is great, I am glad we have it now.
Kind regards
Peter Devoy