Re: [GENERAL] Separating raise notice lines

2009-06-24 Thread Alban Hertroys
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

[GENERAL] Separating raise notice lines

2009-06-23 Thread Radcon Entec
I like to use RAISE NOTICE statements to make sure my functions are working correctly.  I just wrote a trigger function that has the following code:     -- We have a new tender.  Find out who it is.     select into userRecord * from users where users_key = new.tender_key;     if not found then  

Re: [GENERAL] Separating raise notice lines

2009-06-23 Thread Craig Ringer
Radcon Entec wrote: I like to use RAISE NOTICE statements to make sure my functions are working correctly. I just wrote a trigger function that has the following code: [snip] I am trying to insert a carriage return character (chr(10)) in the user name notice so that any subsequent notices