| From: | "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: raise doesn't add end of line |
| Date: | 2008-11-17 15:01:44 |
| Message-ID: | gfs11r$2t6c$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mahmoud ewiwi | 2008-11-18 09:09:44 | custom serial number |
| Previous Message | Pavel Stehule | 2008-11-17 14:31:05 | Re: raise doesn't add end of line |