Tom Lane wrote:

Bruno Wolff III <[EMAIL PROTECTED]> writes:

On Mon, Apr 12, 2004 at 02:26:14 -0400,
Andrew Dunstan <[EMAIL PROTECTED]> wrote:

a few points:
. in CSV mode, NULL should default to '' - that was in what I sent in.

Postgres normally treats an empty string as an empty string. Are you sure
you really want it to be treated as a NULL by default in this one place?

I think that's a spectacularly bad idea too. People who really want that can write "NULL ''", but it shouldn't be implied by CSV mode.

Spectacularly? Hmm.

My approach was that the default should be the most common case. Perhaps on import it's a tossup, but on export a CSV containing lots of \N cells is likely to be ... unexpected.

But, honestly, it's not worth dying in a ditch over.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to