Heikki Linnakangas a écrit :
Laurent Martelli wrote:
to_number('123.0','99') returns 1230, at least on version 7.4 and 8.1. I
think it should return 123 or raise an error.
to_number will silently ignore any character that doesn't match the
pattern. That can be con
The following bug has been logged online:
Bug reference: 3506
Logged by: Laurent Martelli
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4,8.1
Operating system: 7.4->Linux, 8.1->Windows
Description:to_number silently ignore characters
Details:
to_