On Saturday, November 9, 2024, jian he <jian.universal...@gmail.com> wrote: > > > <para> > The <literal>list</literal> format does not distinguish a > <literal>NULL</literal> > value from an empty string. Empty lines are imported as empty strings, > not > as <literal>NULL</literal> values. > </para> > we only mentioned import, not export (COPY TO) dealing with > NULL value. > > Yeah, while not being able to distinguish between the two is consistent with the list format’s premise/design the choice would need to resolve to the null value in order to continue to be data-type agnostic. We’d simply have to note for the text types that empty strings in lists are not supported, and if encountered will be resolved to a null value.
David J.
