Home > mailing lists

ROUND function ?? - Mailing list pgsql-sql

From	Saurabh Mittal
Subject	ROUND function ??
Date	October 9, 2001 02:49:59
Msg-id	OE25NZwwPcMFlF8HGmC0000b0ea@hotmail.com Whole thread Raw
Responses	Re: ROUND function ?? (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-sql

Hi,

select ROUND(0.5) ; returns 0

select ROUND(1.5) ; returns 2;

select ROUND(2.5) ; returns 2;

select ROUND(3.5) ; returns 4;....so on .

I'm sure you would have figured out what's happening !!! Why ??

How do I get to approximate any number x.5 as x+1 ??

Saurabh

From: "Josh Berkus"
Date: 08 October 2001, 22:08:14
Subject: Re: SQL-Programmer tool and field%type support

From: Tom Lane
Date: 09 October 2001, 03:34:40
Subject: Re: SQL-Programmer tool and field%type support