From: | Noah Misch <noah(at)leadboat(dot)com> |
---|---|
To: | Jeff Anton <antonpgsql(at)hesiod(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Zero-padding and zero-masking fixes for to_char(float) |
Date: | 2015-03-25 05:27:55 |
Message-ID: | 20150325052755.GA873601@tornado.leadboat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2015-03-25 05:32:50 | Re: Exposing PG_VERSION_NUM in pg_config |
Previous Message | David Fetter | 2015-03-25 05:21:06 | Re: Exposing PG_VERSION_NUM in pg_config |