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

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.

> inconsistent --- shouldn't it raise a bad-format error instead?
> For example,
>
> regression=# SELECT to_number('12,454.8-', ' ');
> ERROR: Bad numeric input format ' '

Thanks for fix Tom.

Karel