Peter Eisentraut <[EMAIL PROTECTED]> writes:
> SELECT to_number('485-', '999S');
> to_number
> -----------
> 485
> Is this a bug or intentional?
Tracing through this, it looks like the problem is that NUM_processor()
has no switch case for NUM_S (nor does the default case raise an error,
which seems a risky practice to me).
Karel, can you verify this and submit a fix?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
