On Tue, Sep 20, 2011 at 1:39 PM, Kevin Grittner <kevin.gritt...@wicourts.gov> wrote: > These are approximate data types. On what basis do you think the > values returned in your examples are wrong? The demonstrated
Because PostgreSQL still has access to all the significant digits: test1=# SELECT f FROM t WHERE id = 1; f ----------------- 5.63219288e-032 (1 row) Since floats are stored with a significand and an exponent, to_char() should be able to convert 5.6e-32 to text just as easily as it can convert 5.6e-3. For some reason, it doesn't. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs