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/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
