I have not been able to figure out howto return a string of spaces from a postgres PLpgSQL function. For example I have a finalresult field defined as varchar. As I LOOP thru a section of code I set
finalresult := finalresult || '' '' || field1 || '',''|| field2;
and then I issue "RETURN finalresult;" which returns trimmed spacing.
The results I would like are:
field1,field2 field1,field2 field1,field2
but what I get is:
field1,field2 field1,field2 field1,field2
Thanks in advance for the help!
finalresult := finalresult || '' '' || field1 || '',''|| field2;
and then I issue "RETURN finalresult;" which returns trimmed spacing.
The results I would like are:
field1,field2 field1,field2 field1,field2
but what I get is:
field1,field2 field1,field2 field1,field2
Thanks in advance for the help!