Re: round(real,integer) - Mailing list pgsql-general

From Tom Lane
Subject Re: round(real,integer)
Date
Msg-id 16830.1389388163@sss.pgh.pa.us
Whole thread Raw
In response to Re: round(real,integer)  (Paul Ramsey <pramsey@cleverelephant.ca>)
Responses Re: round(real,integer)  (Paul Ramsey <pramsey@cleverelephant.ca>)
List pgsql-general
Paul Ramsey <pramsey@cleverelephant.ca> writes:
> What surprises do you think would come from a
> round(real, integer) returns real
> function? 

People might expect that rounding to, say, 6 digits produces an exact
decimal answer.  Even if you're not exceeding 6 digits overall, it's
unlikely that the answer is *exact*, if it's represented as a float.

            regards, tom lane


pgsql-general by date:

Previous
From: Paul Ramsey
Date:
Subject: Re: round(real,integer)
Next
From: "Day, David"
Date:
Subject: Re: pg_restore - selective restore use cases. HINT use DROP CASCADE