[GENERAL] cannot use result of (insert .. returning)

[Dale Harris]

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.