Home > mailing lists

Re: INSERT... RETURNING with a function - Mailing list pgsql-general

From	Iain Barnett
Subject	Re: INSERT... RETURNING with a function
Date	September 26, 2009 20:00:13
Msg-id	9459BED7-74AF-45CB-B73C-F7FCABCF66A5@gmail.com Whole thread Raw
In response to	Re: INSERT... RETURNING with a function (Adrian Klaver <aklaver@comcast.net>)
List	pgsql-general

On 26 Sep 2009, at 19:57, Tom Lane wrote:

I think you want INSERT ... RETURNING ... INTO some-plpgsql-variable;

regards, tom lane

On 26 Sep 2009, at 19:56, Adrian Klaver wrote:

See:
http://www.postgresql.org/docs/8.4/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW

--
Adrian Klaver
aklaver@comcast.net

Thankyou, that worked. Much appreciated.

regards

Iain

From: Adrian Klaver
Date: 26 September 2009, 19:41:03
Subject: Re:

From: Pavel Stehule
Date: 26 September 2009, 20:10:33
Subject: Re: