Postgres Pro
Downloads
Home   >   mailing lists

Re: cannot use result of (insert .. returning) - Mailing list pgsql-general

From Dale Harris
Subject Re: cannot use result of (insert .. returning)
Date
Msg-id 001001c8fddd$e95487d0$bbfd9770$@com.au
Whole thread Raw
In response to cannot use result of (insert .. returning)  ("Dale Harris" <itsupport@jonkers.com.au>)
List pgsql-general
Tree view

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: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.

pgsql-general by date:

Previous
From: "MuraliPD@GMail"
Date:
Subject: Re: Need help returning record set from a dynamic sql query
Next
From: "Pavel Stehule"
Date:
Subject: Re: cannot use result of (insert .. returning)