Re: numeric_to_number() function skipping some digits

Tom Lane <tgl@sss.pgh.pa.us> wrote: 
> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
>> daveg <daveg@sonic.net> wrote: 
>>> On Tue, Sep 22, 2009 at 10:27:19AM +0530, Jeevan Chalke wrote:
>>>> It seems that Oracle reads formatting string from right-to-left.
> 
>>> It seems worse to to give a wrong answer silently then to throw an
>>> error.  What we do now seems sort of MySqlish.
>  
>> I agree with David on that.
> 
> So who is volunteering to do the presumably rather major rewrite
> involved?
We don't typically identify an author before putting something on the
TODO list.
That said, this one seems like it would be within my skill set.  I
seem to have trouble finding tasks that are for which we can get
consensus, so I just might pick this one up if we achieve such
consensus on it. The biggest problem, should I take it on, would be
that I don't currently have access to an Oracle database, so someone
would have to supply me with accurate specs for how it should behave,
or point to unambiguous documentation.
-Kevin