Re: returned value from SQL statement - Mailing list pgsql-general

From Albe Laurenz
Subject Re: returned value from SQL statement
Date
Msg-id D960CB61B694CF459DCFB4B0128514C201ED1C0B@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: returned value from SQL statement  ("Alain Roger" <raf.news@gmail.com>)
List pgsql-general
Alain Roger wrote:
> the purpose here, it is to solve my problem with a transaction inside a function.

You cannot handle transactions inside a function (apart from using EXCEPTION blocks).
A PostgreSQL function is always executed in a single transaction.

All SQL statements you issue from within a function are in that same transaction.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: page is uninitialized --- fixing
Next
From: Seb
Date:
Subject: Re: casting from integer to boolean