raise statement, how to do multi-line message

From: Leon Starr <leon_starr(at)modelint(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: raise statement, how to do multi-line message
Date: 2011-02-06 06:09:36
Message-ID: A079CFC3-A935-43D5-A4E1-69C140047444@modelint.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Most of my raise statements use short format strings, but every now and then I get a long one that
wraps around in my code and looks ugly. Example:

raise exception 'Delivery specification for Monitored Event [%:%:%] and Notification Template [%] does not exist.',
p_event, p_monitor, p_subscriber, p_template;

Also, assume that I've got this indented a few levels, so that he format string wraps in my code.

Is there any way to break the format string into multiple lines in my code, but still
have a single line message (no line breaks) appear on the console?

I tried this, but it didn't work:

raise exception 'Delivery specification for Monitored Event' || '[%:%:%] and Notification Template [%] does not exist.',
p_event, p_monitor, p_subscriber, p_template;

It's not that big of a deal, but maybe there's a cool trick I need to learn...

- Leon

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Lew 2011-02-06 17:53:20 Re: Backing up several PostgreSQL databases
Previous Message Rolando Edwards 2011-02-05 22:12:45 Re: Backing up several PostgreSQL databases