Horton

Re: Allow round() function to accept float and double precision

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Dean Rasheed <dean.a.rasheed@gmail.com>, "David G. Johnston" <david.g.johnston@gmail.com>, Sayyid Ali Sajjad Rizavi <sasrizavi@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2022-12-01T20:02:09Z
Lists: pgsql-hackers 
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.

			regards, tom lane

Commits

  1. Doc: add example of round(v, s) with negative s.