Thread: PL/pgSQL: how to round a number up?

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

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.
_______________________________