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 up
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 noti
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
r