Re: BUG #6217: to_char() gives incorrect output for very small float values

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Christopher Gernon" <kabigon(at)gmail(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6217: to_char() gives incorrect output for very small float values
Date: 2011-09-20 20:08:08
Message-ID: 4E78AC580200002500041436@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> it would be interesting to know what Oracle etc do with NaN and
> Infinity, assuming they even support such numbers.
>
> Currently what our code does for the format-with-EEEE case is to
> output "#" in all digit positions. It would be plausible for that
> to happen in the non-EEEE cases too, but whether that's actually
> what happens in other systems is something I don't know.

>From a quick web search, it looks like '#' filling is the typical
approach for infinity and NaN.

-Kevin

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Stark 2011-09-20 21:25:54 Re: BUG #6217: to_char() gives incorrect output for very small float values
Previous Message Tom Lane 2011-09-20 19:52:20 Re: BUG #6217: to_char() gives incorrect output for very small float values