On Jun 23, 2009, at 10:27 PM, Radcon Entec wrote:
raise notice 'User name is % %', userRecord.name, chr(10);
I am trying to insert a carriage return character (chr(10)) in the
user name notice so that any subsequent notices will appear on
separate lines. However, when I use a query to update a field that
will fire this trigger, the Messages tab contains this:
NOTICE: User name is capsNOTICE: History record should be added
As you're apparently using a Windows client you probably need to print
\r\n (characters 13 and 10) instead of just \n to make your client
understand the newline. The fault is in the client though, so maybe
you don't want to handle that on the server-side.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4a41e08a759153794312201!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general