On Wed, Sep 14, 2011 at 12:04 PM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> On Wed, 14 Sep 2011, Steve Crawford wrote:
>
>> I suspect you have a multi-line entry and the '+' is just indicating that
>> the field continues.
>
> Steve, et al.:
>
> It's not multi-line, but malformed.
It *is* mult-line. psql uses a '+ to show line breaks:
postgres=# select E'a\nb';
?column?
----------
a +
b
(1 row)
To fix your data, i'd consider using the replace() function to knock
out newlines:
postgres=# select replace(E'a\nb', E'\n', '');
replace
---------
ab
(1 row)
Also consider adjusting the app and/or the database to block them in the future.
merlin
