On Tue, Jun 07, 2005 at 05:49:10PM +0200, Gorodowienko Daniel wrote:
>
> I want to write a function that returns a raise message catched by:
> EXCEPTION
> WHEN RAISE_EXCEPTION THEN
> RETURN .........
> If exception was raise like this:
> RAISE EXCEPTION 'some exception';
> and I want to get 'some exception', so what should I write instead of
> ......... ???
As far as I know you can't do this in any released version of
PostgreSQL, but in 8.1 you'll be able to get the error message
from the SQLERRM variable.
http://archives.postgresql.org/pgsql-committers/2005-06/msg00135.php
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/