Tom Lane wrote:
>> Default display for NULL should be a zero-length string.
>>
>
> That's just as broken as Pavel's suggestion. Unless you have something
> that is guaranteed distingishable from the output of any non-null value,
> you really can't make a significant improvement here.
>
>
>
Right. This is the problem we solved in CSV processing by distinguishing
between quoted and unquoted values that could be null - the CSV rule is
that a null value isn't quoted.
cheers
andrew
