On Saturday, November 9, 2024, jian he <
jian.universality@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.
