> Since a block wasn't exited before the exception was handled, wouldn't
> any database statements in the block stand?
> Assume for a moment that it wasn't a constraint violation, but a table
> trigger throwing a custom exception, and the catch block handles it
> instead of handling constraint violations.
>
> FB exception syntax confuses me, as I'm used to other languages where
> the catch is outside the block.

E.g. like in Java? Right.

try {
...
} catch ... {
...
}


The catch (WHEN) block in Firebird PSQL needs to be at the last part of
a BEGIN ... END block.

While you can't do something like that (i = 1 after the exception
handler in the some begin/end block):

declare i integer;
begin
i = 0;
begin
while (i <= 20) do
begin
i = i + 1;
insert into t4(T4_ID) values (:i);
when any do
begin
end
i = 1;
end
end
end


It's fine to continue with something in context of the outer begin/end
block, e.g.:

declare i integer;
begin
i = 0;
begin
while (i <= 20) do
begin
i = i + 1;
insert into t4(T4_ID) values (:i);
when any do
begin
end
end
i = 1;
end
end


Regards
Thomas