Re: ROLLBACK in a function?

Rory Campbell-Lange <rory@campbell-lange.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.

-0Doug