Re: PL/pgSQL: how to round a number up? - Mailing list pgsql-general

From Bricklen Anderson
Subject Re: PL/pgSQL: how to round a number up?
Date
Msg-id 4384D94F.4050007@PresiNET.com
Whole thread Raw
In response to PL/pgSQL: how to round a number up?  (Script Head <scripthead@gmail.com>)
List pgsql-general
Script Head wrote:
> In PL/pgSQL the round() function seem to round a number down all the
> time. Is there something like ceil() that would round it up?
>
> ScriptHead

Yup, it's called ceil(). Oh! You just said that ;)

Can also use ceiling()

--
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________

pgsql-general by date:

Previous
From: Script Head
Date:
Subject: PL/pgSQL: how to round a number up?
Next
From: Adam Witney
Date:
Subject: Re: "invalid page header in block 597621 of relation..."error