ON CONFLICT DO NOTHING RETURNING

Поиск
Список
Период
Сортировка
От Peter Devoy
Тема ON CONFLICT DO NOTHING RETURNING
Дата
Msg-id CABoFc_hxX7F9n_nTGFP5-9y-Qy5v9_Wgn5j4DSaD8q-Gx0g=6w@mail.gmail.com
обсуждение исходный текст
Ответы Re: ON CONFLICT DO NOTHING RETURNING  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-general
Дерево обсуждения
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: Suppress decimal point like digits in to_char?
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Unexpected result using floor() function