Re: Throwing exceptions

[Michael Glaesemann <grzm(at)seespotcode(dot)net>]

On Jun 25, 2007, at 19:01 , Michael Glaesemann wrote:

> The message is just a string. Assign the message to a variable and  
> use the variable in place of the message. For example, in PL/pgSQL:
>
> k_error_message := 'Boom! %';
> RAISE EXCEPTION k_error_message, v_foo.id;

I was wrong. The message is not just a string, but you can  
interpolate the message text (and other variables) like so:

RAISE EXCEPTION '%, %', k_error_message, v_foo_id;

Michael Glaesemann
grzm seespotcode net