Re: raise doesn't add end of line

Поиск
Список
Период
Сортировка
От Sabin Coanda
Тема Re: raise doesn't add end of line
Дата
Msg-id gfs11r$2t6c$1@news.hub.org
обсуждение исходный текст
Ответ на raise doesn't add end of line  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
Список 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 по дате отправления:

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: raise doesn't add end of line
Следующее
От: mahmoud ewiwi
Дата:
Сообщение: custom serial number