I’ve found my solution as in the help file under “RETURNING INTO”. It would be nice if this was referenced on the INSERT documentation.
Dale
From: pgsql-general-owner@postgresql.org
Sent: Thursday, 14 August 2008 15:32To: pgsql-general@postgresql.orgSubject: [GENERAL] cannot use result of (insert .. returning)
Hello,
I’m having the same issues as dvs had in message thread http://archives.postgresql.org/pgsql-general/2008-05/msg01117.php as I want to be able to use the result from an INSERT INTO table(...) VALUES(...) RETURNING new_row_ID.
I would ideally like to be able to capture the RETURNING value into a variable to use immediately. Does anyone have a solution?
Dale.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных