Re: Transactions and ID's generated by triggers

On 28 Feb 2011, at 22:07, Andre Lopes wrote:

> Hi,
>
> Thanks for the reply.
>
> How can I user the RETURNING without pl/sql? My PostgreSQL version is 8.3
>
> Can you give me some example?

http://www.postgresql.org/docs/8.3/interactive/sql-insert.html

Most notably the last example on that page.

> On Mon, Feb 28, 2011 at 7:00 PM, Alban Hertroys
> <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> wrote:
>> On 28 Feb 2011, at 24:37, David Johnston wrote:
>>
>>> Using pl/pgsql you can:
>>
>> You don't need pl/pgsql for that. You can return the resultset of the first insert into a client-side variable (while still making use of the RETURNING-clause of course).
>>
>> Of course, the benefit of using pl/pgsql for this is that you could make the desired behaviour independent of client-implementations (which are all too likely to differ if there are multiple types of clients). However, for that to work reliably you will need to do some extra work to make sure it's the only possible code-path for inserting those records.
>>
>> Alban Hertroys
>>
>> --
>> If you can't see the forest for the trees,
>> cut the trees and you'll see there is no forest.
>>
>>
>>
>>
>>
>>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.

!DSPAM:737,4d6c2543235881724113336!