Re: Unnexpected results using to_number()

"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
inconsistent --- shouldn't it raise a bad-format error instead?
For example,

regression=# SELECT to_number('12,454.8-', ' ');
ERROR: Bad numeric input format ' '

Seems odd that no spaces means "return NULL" but 1 or more spaces
doesn't.

regards, tom lane