Re: cannot use result of (insert .. returning)

Поиск

Список

Период

Сортировка

От	Dale Harris
Тема	Re: cannot use result of (insert .. returning)
Дата	14 августа 2008 г. 07:21:37
Msg-id	001001c8fddd$e95487d0$bbfd9770$@com.au обсуждение исходный текст
Ответ на	cannot use result of (insert .. returning) ("Dale Harris" <itsupport@jonkers.com.au>)
Список	pgsql-general

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 по дате отправления:

От: "MuraliPD@GMail"
Дата: 14 августа 2008 г., 06:54:33
Сообщение: Re: Need help returning record set from a dynamic sql query

От: "Pavel Stehule"
Дата: 14 августа 2008 г., 07:59:33
Сообщение: Re: cannot use result of (insert .. returning)