Re: PROPOSAL - User's exception in PL/pgSQL

Pavel Stehule wrote:
>     DECLARE excpt EXCEPTION [= 'SQLSTATE']

What would this default to? (i.e. if no '= SQLSTATE' is specified)

> Rules:
>  o User can specify SQLSTATE only from class 'U1' 
>  o Default values for SQLSTATE usr excpt are from class 'U0'

Can you elaborate on what you mean?

>  o Every exception's variable has unique SQLSTATE
>  o User's exception or system's exception can be raised only with
>    level EXCEPTION

It might be worth allowing a custom SQLSTATE to be specified for 
non-exception RAISEs -- there are already WARNING SQLSTATE error codes 
(see ERRCODE_WARNING).

-Neil