Re: About how to use "exception when ??? then "

> <snip> From the page:
> "The PL/pgSQL condition name for each error code is the same as the 
> phrase shown in the table, with underscores substituted for spaces. 
> For example, code 22012, DIVISION BY ZERO, has condition name 
> DIVISION_BY_ZERO. Condition names can be written in either upper or 
> lower case.


> (Note that PL/pgSQL does not recognize warning, as opposed to error, 
> condition names; those are classes 00, 01, and 02.)"


That means pl/pgsql will not recognize error codes under classes 00, 01, 
02.

Is there a way, I can output error code?
exception when ... then when others then  raise notice '%, %', SQLSTATE, SQLERRM;

But it seems that SQLERRM and SQLSTATE did not work for me. By the way, 
I am using postgresql 8.0.1.

Thanks a lot,
Ying

> <snip>