I have some sql code that was working in a report, after upgrading from 6.3 > 7.2 comunity version I now get an validation error.
I have tracked this down to this section of code
regexp_replace(replace(customer.accounts_note,',',''), E'[\\n\\r]+', ',,', 'g' ) as reg_rep
if I change the \\n\\r for something else all is ok. where is this turned off as I have to remove blank lines from my output
any help would be good