Re: round(real,integer)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul Ramsey <pramsey(at)cleverelephant(dot)ca>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: round(real,integer)
Date: 2014-01-10 21:09:23
Message-ID: 16830.1389388163@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Paul Ramsey <pramsey(at)cleverelephant(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Day, David 2014-01-10 21:45:57 Re: pg_restore - selective restore use cases. HINT use DROP CASCADE
Previous Message Paul Ramsey 2014-01-10 20:52:43 Re: round(real,integer)