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

On Sun, 9 Jul 2000, Tom Lane wrote:

> "Andrew Snow" <andrew@modulus.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