Question about expressions with raise plpgsql statement in coming 8.1

Started by Laurent HERVEover 20 years ago2 messagesgeneral
Jump to latest
#1Laurent HERVE
laurent-herve@club-internet.fr

Hi,

I would like to know if the PlPgSQL RAISE statement will be able to take
expressions for the format string in 8.1.
I checked the patches mailing list but I didn't find a clear answer.

I have to send error messages in several languages within PlPgSQL code.
I would like RAISE to work like that :

RAISE EXCEPTION get_my_format_string(MY_ERR_NBR,USER_LANG),a,b,a+b/c;

where the get_my_format_string returns a format string understandable for
RAISE for each valid combination of MY_ERR_NBR and USER_LANG.

Regards,

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Laurent HERVE (#1)
Re: Question about expressions with raise plpgsql statement in coming 8.1

Laurent HERVE <laurent-herve@club-internet.fr> writes:

I would like to know if the PlPgSQL RAISE statement will be able to take
expressions for the format string in 8.1.

As of CVS tip it still seems to want a literal string constant there.

regards, tom lane