Re: [HACKERS] Re: Unnexpected results using to_number()

Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> writes:
> On Sun, 9 Jul 2000, Tom Lane wrote:
>> "Andrew Snow" <andrew(at)modulus(dot)org> writes:
>>>> # SELECT to_number('12,454.8-', '');
>>>> pqReadData() -- backend closed the channel unexpectedly.
>>
>> In current sources I get a NULL result, which seems to be what the
>> code author intended originally. However this seems a little bit

> my original code not return NULL, but return numeric_in(NULL, 0, 0) for
> this situation.

Yeah, I know. What did you expect that to produce, if not a NULL?

>> inconsistent --- shouldn't it raise a bad-format error instead?

What do you think about raising an error instead of returning NULL?

regards, tom lane