On Tue, Mar 24, 2015 at 09:26:10AM -0700, Jeff Anton wrote: > The issue of significant (decimal) digits to and from floating point > representation is a complex one. > > What 'significant' means may depend upon the intent.
True. I meant simply that Oracle TO_CHAR emits no more than 17 nonzero digits for a BINARY_DOUBLE and no more than 9 nonzero digits for a BINARY_FLOAT. > BTW: This is my first posting to this list. I should introduce myself. > I'm Jeff Anton. I was the first Postgres project lead programmer working > for Michael Stonebraker at U.C. Berkeley a very long time ago. > The first version was never released. I've since worked for several db > companies. Welcome back. Thanks, nm -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
