2009/8/10 Tom Lane <t...@sss.pgh.pa.us>: > Brendan Jurd <dire...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers