On Jun 21, 2007, at 10:30 , Germán Hüttemann Arza wrote:
I need a way to throw a message in a function, when an exception
occurs, but I
don't want to write again and again the same message in every place
I need to
throw it. So, is there a way to handle this situation in a more
general
manner?
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;
Hope that helps.
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
