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 pag
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?
Best Regards,
On Mon, Feb 28, 2011 at 7:00 PM, Alban Hertroys
wrote:
> On 28 Feb 2011, at 24:37, David Johnston wrote:
>
>> Using pl/pgsql you can:
>
> You don'
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
that you need.
>
> David J.
>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andre Lopes
> Sent: Sunday, February 27, 2011 3:34 PM
> To: postgresql Forums
> Subject: [GENERAL] Transactions
2011 3:34 PM
To: postgresql Forums
Subject: [GENERAL] Transactions and ID's generated by triggers
Hi,
I have a situation that I dont know how to deal.
I have 2 tables "tdir_uris_files" and "tdir_uri_files_details". Please see the
Image in attach.
The table "tdi
Hi,
I have a situation that I dont know how to deal.
I have 2 tables "tdir_uris_files" and "tdir_uri_files_details". Please
see the Image in attach.
The table "tdir_uris_files" have the field "id_ordinal" that is
originated by a trigger(before insert)
The table "tdir_uri_files_details" use the f
