Re: raise doesn't add end of line - Mailing list pgsql-sql

From Sabin Coanda
Subject Re: raise doesn't add end of line
Date
Msg-id gfs11r$2t6c$1@news.hub.org
Whole thread Raw
In response to raise doesn't add end of line  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgsql-sql
Hi Pavel,

I tried on Windows, and it works. Thanks a lot.

BTW, I didn't succeed to find char(10) workaround because I tried at the end 
of the line, where ... it doesn't work.

For instance check the function:

-- Function: r()

-- DROP FUNCTION r();

CREATE OR REPLACE FUNCTION r() RETURNS void AS
$BODY$begin
raise notice 'Break the 1st%line...', chr(10);
raise notice 'eol on 2nd line...%', chr(10);
raise notice '3rd line';
end; $BODY$ LANGUAGE 'plpgsql' VOLATILE COST 100;
ALTER FUNCTION r() OWNER TO postgres;


Run it:   SELECT r()

And you get:

NOTICE:  Break the 1st
line...NOTICE:  eol on 2nd line...NOTICE:  3rd line





pgsql-sql by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: raise doesn't add end of line
Next
From: mahmoud ewiwi
Date:
Subject: custom serial number