cannot use result of (insert .. returning)

Поиск
Список
Период
Сортировка
От Dale Harris
Тема cannot use result of (insert .. returning)
Дата
Msg-id 000201c8fdcf$1aa4e190$4feea4b0$@com.au
обсуждение исходный текст
Ответы Re: cannot use result of (insert .. returning)  ("Dale Harris" <itsupport@jonkers.com.au>)
Re: cannot use result of (insert .. returning)  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Список pgsql-general

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: mirroring table
Следующее
От: Gnanavel Shanmugam
Дата:
Сообщение: Re: Need help returning record set from a dynamic sql query