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: [EMAIL PROTECTED] Sent: Thursday, 14 August 2008 15:32 To: pgsql-general@postgresql.org Subject: [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.
