Re: [BUGS] BUG #3506: to_number silently ignore characters

2007-08-03 Thread Laurent Martelli
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

[BUGS] BUG #3506: to_number silently ignore characters

2007-08-02 Thread Laurent Martelli
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_