Trouble with Newline in plpgsql

[iteration9x]

Hi I'm trying to concatenate to strings together with a newline.

CREATE OR REPLACE FUNCTION concat() RETURNS TEXT AS '

DECLARE
str text;
strn text = E'\n' <- This breaks.

BEGIN

str = ''number of completed'' || strn;
str = str || str;
RETURN str;

END
' Language plpgsql;

Thanks for your help!
Patrick

 

[feherke]

Hi

No idea, but try [tt]chr(10)[/tt] instead of [tt]'\n'[/tt].

Feherke.

http://rootshell.be/~feherke/

 

[iteration9x]

Thanks, but that didn't work.

 

[iteration9x]

Weirdly, it didn't work if I did this

strn text = chr(10);

str = ''something'' || strn;


but it did work if I did this,

str = ''something'' || chr(10);

So thanks alot!