plpgsql NULL statement (was Re: [GENERAL] Postgres 8.0 -> BEGIN EXCEPTION END Syntax????)

Daniel Schuchardt <daniel_schuchardt(at)web(dot)de> writes:
> BEGIN
> exception ...
> EXCEPTION
> WHEN OTHERS THEN ?????????????what to write for do nothing?????????
> END;

> in oracle it's
> WHEN OTHERS THEN null;
> but this syntax doesn't work in postgres.

In Postgres you just write nothing at all:

BEGIN
...
EXCEPTION
WHEN OTHERS THEN
END;

However, it does appear that Oracle's PL/SQL has such a statement,
and that they don't like empty exception sections (or empty if/then/else
arms, etc), but *require* you to write "NULL;" in these places.
It seems to me that it would ease porting of Oracle functions if
we allowed a NULL statement in plpgsql.

It looks like about five minutes' work to add such a thing ... anyone
have any objections?

regards, tom lane