Re: SQL error: function round(double precision, integer) does

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tjo(at)acm(dot)org
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL error: function round(double precision, integer) does
Date: 2005-02-28 21:54:28
Message-ID: 873.1109627668@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"TJ O'Donnell" <tjo(at)acm(dot)org> writes:
> Is there some fundamental reason for round(dp) but round(numeric,int)?

I think the main argument against supporting round(dp,int) is that the
result would be inherently inexact (at least for int>0).

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Don Drake 2005-03-01 00:40:39 Re: AutoCommit and DDL
Previous Message T E Schmitz 2005-02-28 20:48:10 psql encoding problem