BUG #3506: to_number silently ignore characters

From: "Laurent Martelli" <lmartelli(at)seditel(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3506: to_number silently ignore characters
Date: 2007-08-02 09:43:45
Message-ID: 200708020943.l729hjwd002807@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3506
Logged by: Laurent Martelli
Email address: lmartelli(at)seditel(dot)fr
PostgreSQL version: 7.4,8.1
Operating system: 7.4->Linux, 8.1->Windows
Description: to_number silently ignore characters
Details:

to_number('123.0','999999') returns 1230, at least on version 7.4 and 8.1. I
think it should return 123 or raise an error.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-08-02 14:17:29 Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Previous Message Heikki Linnakangas 2007-08-02 08:03:57 Re: BUG #3504: Some listening sessions never return from writing, problems ensue