Re: INSERT... RETURNING with a function

From: Iain Barnett <iainspeed(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: INSERT... RETURNING with a function
Date: 2009-09-26 19:59:27
Message-ID: 9459BED7-74AF-45CB-B73C-F7FCABCF66A5@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)comcast(dot)net

Thankyou, that worked. Much appreciated.

regards
Iain

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2009-09-26 20:10:20 Re:
Previous Message Krzysztof Barlik 2009-09-26 19:49:03 Re: Column names in rowsets returned from function