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 4E78AC580200002500041436@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>)
List pgsql-bugs
Tom Lane <tgl@sss.pgh.pa.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

pgsql-bugs by date:

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