Postgres Pro
Downloads
Home   >   mailing lists

BUG #3506: to_number silently ignore characters - Mailing list pgsql-bugs

From Laurent Martelli
Subject BUG #3506: to_number silently ignore characters
Date
Msg-id 200708020943.l729hjwd002807@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3506: to_number silently ignore characters
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      3506
Logged by:          Laurent Martelli
Email address:      lmartelli@seditel.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.

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Next
From: Tom Lane
Date:
Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue