2009/8/10 Tom Lane <tgl@sss.pgh.pa.us>:
> Brendan Jurd <direvus@gmail.com> writes:
>> Here's version 7.
>
> Applied with a couple of corrections: the numeric case wasn't dealing
> with NaNs in the same way as the float cases, and the int8 case was
> converting to float8 which would lose precision. I made it go through
> numeric instead, which is pretty expensive but I doubt this is worth
> expending extra code on.
>
> regards, tom lane
>
It's nice. I am playing with it, and now I found some potential issue.
The parser is maybe too tolerant:
postgres=# select to_char(3.14323,'9.9(aaaaaEEEE');to_char
---------- 3.1e+00
(1 row)
regards
Pavel Stehule