Re: what is good solution for support NULL inside string_to_array function? - Mailing list pgsql-hackers

Josh Berkus <josh@agliodbs.com> writes:
>> quietly removing NULL is maybe good for compatibility but is wrong for
>> functionality. 

> I agree.  I wasn't aware of this little misfeature.

> 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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY is not working
Next
From: Andrew Dunstan
Date:
Subject: Re: what is good solution for support NULL inside string_to_array function?