Re: Syntax decisions for pl/pgsql RAISE extension

On May 12, 2008, at 11:53 AM, Tom Lane wrote:
> 3. I think we should allow the user to specify the error message the
> same way as the other options, that is
> RAISE level USING MESSAGE = string_expression [ , ... ]
> The %-format business has always struck me as a bit weird, and it's
> much more so if we aren't handling the other error report components
> in the same fashion. So we ought to provide an alternative that's
> more uniform.

I'm entirely in favor of allowing string expressions; that's always
been a huge shortcoming in RAISE.

I'm entirely opposed to getting rid of % substitution. It's
incredibly useful; I have it in probably 80% of my RAISE statements.
It encourages providing more detailed error messages, which is a Good
Thing.
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828