Re: [HACKERS] Fwd: Copy out wording

2009-09-17 Thread Bruce Momjian
Andrew Dunstan wrote: > > > Bruce Momjian wrote: > > Magnus Hagander wrote: > > > >> On Thu, Sep 3, 2009 at 13:31, Andrew Dunstan wrote: > >> > >>> Magnus Hagander wrote: > >>> > Oh, hang on, "the NULL string" refers to the copy parameter? Not a > part of the data? I read

Re: [HACKERS] Fwd: Copy out wording

2009-09-17 Thread Andrew Dunstan
Bruce Momjian wrote: Magnus Hagander wrote: On Thu, Sep 3, 2009 at 13:31, Andrew Dunstan wrote: Magnus Hagander wrote: Oh, hang on, "the NULL string" refers to the copy parameter? Not a part of the data? I read it as "a string being NULL". Maybe something like "the value of th

Re: [HACKERS] Fwd: Copy out wording

2009-09-17 Thread Bruce Momjian
Magnus Hagander wrote: > On Thu, Sep 3, 2009 at 13:31, Andrew Dunstan wrote: > > > > > > Magnus Hagander wrote: > >> > >> Oh, hang on, "the NULL string" refers to the copy parameter? Not a > >> part of the data? I read it as "a string being NULL". Maybe something > >> like "the value of the NULL st

Re: [HACKERS] Fwd: Copy out wording

2009-09-03 Thread Magnus Hagander
On Thu, Sep 3, 2009 at 13:31, Andrew Dunstan wrote: > > > Magnus Hagander wrote: >> >> Oh, hang on, "the NULL string" refers to the copy parameter? Not a >> part of the data? I read it as "a string being NULL". Maybe something >> like "the value of the NULL string parameter" to be overly clear for

Re: [HACKERS] Fwd: Copy out wording

2009-09-03 Thread Andrew Dunstan
Magnus Hagander wrote: Oh, hang on, "the NULL string" refers to the copy parameter? Not a part of the data? I read it as "a string being NULL". Maybe something like "the value of the NULL string parameter" to be overly clear for people like me? :-) We could change: A NULL is output as

Re: [HACKERS] Fwd: Copy out wording

2009-09-03 Thread Magnus Hagander
On Thu, Sep 3, 2009 at 13:19, Andrew Dunstan wrote: > > > Magnus Hagander wrote: >> >> Our documentation for COPY >> (http://www.postgresql.org/docs/8.4/static/sql-copy.html) has the >> following to say: >> " >>  The CSV format has no standard way to distinguish a NULL value from >> an empty string

Re: [HACKERS] Fwd: Copy out wording

2009-09-03 Thread Andrew Dunstan
Magnus Hagander wrote: Our documentation for COPY (http://www.postgresql.org/docs/8.4/static/sql-copy.html) has the following to say: " The CSV format has no standard way to distinguish a NULL value from an empty string. PostgreSQL's COPY handles this by quoting. A NULL is output as the NULL s

[HACKERS] Fwd: Copy out wording

2009-09-03 Thread Magnus Hagander
Crap, I just realized I sent to pgadmin hackers by mystake. Meh. Our documentation for COPY (http://www.postgresql.org/docs/8.4/static/sql-copy.html) has the following to say: "  The CSV format has no standard way to distinguish a NULL value from an empty string. PostgreSQL's COPY handles this b