Re: numeric rounding

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Gezeala 'Eyah' Bacuño II <gezeala25(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: numeric rounding
Date: 2003-09-29 15:34:03
Message-ID: 20030929153403.GC21235@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 29, 2003 at 12:47:05AM -0700, Gezeala 'Eyah' Bacuño II wrote:

> my problem is my function just won't round some numbers properly..
> what i want it to do is like this.
>
> example:
>
> 721.875 = 721.88

a=> select round(721.875, 2);
round
--------
721.88
(1 row)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La primera ley de las demostraciones en vivo es: no trate de usar el sistema.
Escriba un guión que no toque nada para no causar daños." (Jakob Nielsen)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-09-29 15:34:05 Re: Edward
Previous Message Alvaro Herrera 2003-09-29 15:31:41 Re: downloading latest source from cvs