Tom Lane wrote:
>Can anyone check how well the syntax of plpgsql EXCEPTION, as described
>agrees with what Oracle does? I did some googling but couldn't find
>anything that seemed authoritative. I'm wondering in particular if
>Oracle allows multiple condition names per WHEN, along the lines of
> WHEN condition [ , condition ... ] THEN
>Also it would be nice to see a complete list of the "condition" names
>that they accept. I whipped up a quick table based on our ERRCODE
>macro names, see
>but I'm certain that's not what we really want to expose to users
>in the long run.
It appears you can have multiple exceptions in a single handler, but
that the separator is 'OR' rather than ','.
The page also gives a link to a list of the predefined exceptions.
PL/SQL allows users to define and raise their own exceptions too.
In response to
pgsql-hackers by date
|Next:||From: Joshua D. Drake||Date: 2004-07-31 17:13:25|
|Subject: Re: Anybody have an Oracle PL/SQL reference at hand?|
|Previous:||From: Peter Eisentraut||Date: 2004-07-31 16:33:00|
|Subject: Re: Compile failure on nl_langinfo|