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 [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
