Bruce Momjian wrote:
Also, can you explain why we can't read across a newline to the next quote? Is it a problem with the way our code is structured or is it a logical problem? Someone mentioned multibyte encodings but I don't understand how that applies here.
In a CSV file, each line is a record. Reading across a newline for the next quote (assuming the next field is quoted) would mean stealing fields from the next record.
I did see one complaint about missing or extra fields at the end of a record - I think it is reasonable for us to expect the data to be rectangular, and not ragged.
(I hope this answers your question - I am not 100% certain I understaood it).
cheers
andrew
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
