| From: | Bricklen Anderson <BAnderson(at)PresiNET(dot)com> |
|---|---|
| To: | Script Head <scripthead(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PL/pgSQL: how to round a number up? |
| Date: | 2005-11-23 21:04:15 |
| Message-ID: | 4384D94F.4050007@PresiNET.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
_______________________________
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Witney | 2005-11-23 21:23:15 | Re: "invalid page header in block 597621 of relation..."error |
| Previous Message | Script Head | 2005-11-23 21:01:03 | PL/pgSQL: how to round a number up? |