Re: BUG #6217: to_char() gives incorrect output for very small float values - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #6217: to_char() gives incorrect output for very small float values
Date
Msg-id 4E78A6890200002500041430@gw.wicourts.gov
Whole thread Raw
In response to Re: BUG #6217: to_char() gives incorrect output for very small float values  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #6217: to_char() gives incorrect output for very small float values  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
>> Christopher Gernon <kabigon@gmail.com> wrote:
>>> to_char() should be able to convert 5.6e-32 to text just as
>>> easily as it can convert 5.6e-3. For some reason, it doesn't.
>
>> Oh, I see your point now, and I agree with you.
>
>> We should probably at least put this on the TODO list, I think.
>> Any objections?
>
> If we're gonna fix it, we should just fix it, I think.  I was
> considering taking a stab at it, but if someone else would like
> to, that's fine too.

I wouldn't mind doing it, but not until after the CF wraps.  On the
other hand, isn't this is one of those compatibility functions?
Perhaps it would best be done by someone who has familiarity with,
and access to, a database with which we're trying to be compatible.

-Kevin

pgsql-bugs by date:

Previous
From: Christopher Gernon
Date:
Subject: Re: BUG #6217: to_char() gives incorrect output for very small float values
Next
From: Tom Lane
Date:
Subject: Re: BUG #6217: to_char() gives incorrect output for very small float values