Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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.
_______________________________

In response to

pgsql-general by date

Next:From: Adam WitneyDate: 2005-11-23 21:23:15
Subject: Re: "invalid page header in block 597621 of relation..."error
Previous:From: Script HeadDate: 2005-11-23 21:01:03
Subject: PL/pgSQL: how to round a number up?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group