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

From Steve Crawford
Subject Re: what is good solution for support NULL inside string_to_array function?
Date
Msg-id 4BE45386.9010109@pinpointresearch.com
Whole thread Raw
In response to Re: what is good solution for support NULL inside string_to_array function?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 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
>
>   
Is this, perhaps, a generalized case of this long-running discussion 
from last year?: 
http://archives.postgresql.org/pgsql-hackers/2009-03/msg01350.php

Cheers,
Steve



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: beta to release
Next
From: Josh Berkus
Date:
Subject: Re: no universally correct setting for fsync