On Dec 11, 2012 9:28 PM, "David Gould" <da...@sonic.net> wrote: > > Thank you. I got the example via cut and paste from email and pasted it > into psql on different hosts. od tells me it ends each line with: > > \n followed by 0xC2 0xA0 and then normal spaces. The C2A0 thing is > apparently NO-BREAK SPACE. Invisible, silent, odorless but still deadly. > > Which will teach me not to accept text files from the sort of people who > write code in Word I guess.
It's not just Word... I was bitten by this last week by a WYSIWYG HTML widget I was using to write some documentation. When I copied the examples I had created out of said environment during a final technical accuracy pass and they failed to run in psql, I panicked for a few minutes. I eventually determined that, rather than just wrapping my code in <pre> tags, the widget had created entities that were faithfully converted into Unicode non-breaking spaces in the psql input.
