Reg Me Please escribió: > Il Thursday 02 October 2008 16:15:10 Alvaro Herrera ha scritto: > > You can nest blocks arbitrarily, giving you the chance to selectively > > rollback pieces of the function. It's only a bit more awkward. > > You mean I can issue a ROLLBACK command within a BEGIN...END; block to roll it > back? No -- I mean you can use BEGIN/EXCEPTION/END blocks as you like, nesting them or putting one after another. Complementing this with RAISE EXCEPTION you can cause savepoints to roll back at will. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
