[GENERAL] Missing feature - how to differentiate insert/update in plpgsqlfunction?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема [GENERAL] Missing feature - how to differentiate insert/update in plpgsqlfunction?
Дата
Msg-id 20170215140502.GA25364@depesz.com
обсуждение исходный текст
Ответы Re: [GENERAL] Missing feature - how to differentiate insert/update inplpgsql function?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: [GENERAL] Missing feature - how to differentiate insert/updatein plpgsql function?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-general
Hi,
I have a function, in PostgreSQL 9.6, which does:

INSERT INTO table () values (...)
ON CONFLICT DO UPDATE ...;

The thing is that the function should return information whether the row
was modified, or created - and currently it seems that this is not
available. Or am I missing something?

Best regards,

depesz



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

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: [GENERAL] Bad planning data resulting in OOM killing of postgres
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Missing feature - how to differentiate insert/update inplpgsql function?