Question about expressions with raise plpgsql statement in coming 8.1

From: Laurent HERVE <laurent-herve(at)club-internet(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Question about expressions with raise plpgsql statement in coming 8.1
Date: 2005-08-22 11:20:28
Message-ID: 200508221320.28283.laurent-herve@club-internet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pailloncy Jean-Gerard 2005-08-22 11:45:57 Rules UPDATE
Previous Message Clodoaldo Pinto 2005-08-22 09:47:32 Re: extract (dow/week from date)