Re: raise doesn't add end of line

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: Raw Message | Whole Thread | 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

In response to

Browse pgsql-sql by date

  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