"Chris Gernon" <kabi...@gmail.com> wrote: > The to_char() function gives incorrect output for float values > whose decimal expansion has several digits (more than somewhere > around 14-15) after the decimal point. These are approximate data types. On what basis do you think the values returned in your examples are wrong? The demonstrated results don't surprise me, given that they match to about the limits of the approximate data type involved. It also wouldn't surprise me to see slightly different results on different architectures or operating systems. If you want exact values, you should use a type which supports that, like numeric. -Kevin
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
