Why no exprs in format string to RAISE

Lists: pgsql-sql
From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Why no exprs in format string to RAISE
Date: 2004-07-04 21:21:53
Message-ID: 1088976113.2767.7.camel@teetnang
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-sql

Hi,

is there a non-implementation reason as to why there are no expressions
allowed in the arguments to the format string to RAISE, or is that just
not implemented yet?

Thanks.

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>


From: Richard Huxton <dev(at)archonet(dot)com>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Why no exprs in format string to RAISE
Date: 2004-07-05 11:34:04
Message-ID: 40E93CAC.3000106@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-sql

Markus Bertheau wrote:
> Hi,
>
> is there a non-implementation reason as to why there are no expressions
> allowed in the arguments to the format string to RAISE, or is that just
> not implemented yet?

Just not done yet AFAIK. It would require some changes to the parser for
plpgsql, but nothing too extreme. Might make a good project for
someone learning more about PG's code.

--
Richard Huxton
Archonet Ltd


From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Markus Bertheau <twanger(at)bluetwanger(dot)de>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Why no exprs in format string to RAISE
Date: 2004-07-06 17:26:17
Message-ID: 200407061726.i66HQHW25276@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-sql

Richard Huxton wrote:
> Markus Bertheau wrote:
> > Hi,
> >
> > is there a non-implementation reason as to why there are no expressions
> > allowed in the arguments to the format string to RAISE, or is that just
> > not implemented yet?
>
> Just not done yet AFAIK. It would require some changes to the parser for
> plpgsql, but nothing too extreme. Might make a good project for
> someone learning more about PG's code.

TODO has:

o Allow PL/PgSQL's RAISE function to take expressions

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073