Re: ROLLBACK in a function?

On 28/05/03, Doug McNaught (doug(at)mcnaught(dot)org) wrote:
> Rory Campbell-Lange <rory(at)campbell-lange(dot)net> writes:
>
> > I understand that functions provide an implied transaction in
> > PostgreSQL.
>
> Not quite. Every SQL statement is executed in its own transaction if
> BEGIN/END are not explicitly used. A statment may cause zero, one or
> many function calls, but they will all execute in that transaction.
>
> > Does that mean one can ROLLBACK/COMMIT within the body of a
> > function?
>
> Not in current versions.

So in my (eg php) code I should do something like this psuedo code?

BEGIN WORK
select function ([params])
if
result == 0
then
rollback
else
commit
end if
END WORK

Rory
--
Rory Campbell-Lange
<rory(at)campbell-lange(dot)net>
<www.campbell-lange.net>