Re: Allow round() function to accept float and double precision - Mailing list pgsql-hackers

From David Rowley
Subject Re: Allow round() function to accept float and double precision
Date
Msg-id CAApHDvq5gnYfzvxRAdO097j0X0hQ_gQFSnZCdY3_2ZndP6F3MQ@mail.gmail.com
Whole thread Raw
In response to Re: Allow round() function to accept float and double precision  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Allow round() function to accept float and double precision  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
On Fri, 2 Dec 2022 at 09:02, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> David Rowley <dgrowleyml@gmail.com> writes:
> > I don't really agree that it will work fine in all cases though. If
> > the numeric has more than 1000 digits left of the decimal point then
> > the method won't work at all.
>
> But what we're talking about is starting from a float4 or float8
> input, so it can't be more than ~308 digits.

I may have misunderstood. I thought David J was proposing this as a
useful method for rounding numeric too. Re-reading what he wrote, I no
longer think he was.

David



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Error-safe user functions
Next
From: David Rowley
Date:
Subject: Re: Questions regarding distinct operation implementation