Daniel Schuchardt <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
