Content-Type: text/plain;
  charset="iso-8859-1"
From: Steve Crawford <scrawford@pinpointresearch.com>
Organization: Pinpoint Research
To: "Katka a Daniel Dunajsky" <daniel_katka@hotmail.com>,
	pgsql-sql@postgresql.org
Subject: Re: How to increase precision?
Date: Fri, 2 May 2003 14:13:31 -0800
References: <Law12-F72YKpDS7hx2700007b3c@hotmail.com>
In-Reply-To: <Law12-F72YKpDS7hx2700007b3c@hotmail.com>
MIME-Version: 1.0
Message-Id: <20030502221331.86C2B103C9@polaris.pinpointresearch.com>
Content-Transfer-Encoding: quoted-printable

It's assuming INTs and doing int division. Make one a numeric/real or=20
explicitly cast:

steve=3D# select 5/2;
 ?column?=20
----------
        2
(1 row)

steve=3D# select 5./2;
 ?column?=20
----------
      2.5
(1 row)

Cheers,
Steve


On Friday 02 May 2003 2:38 pm, Katka a Daniel Dunajsky wrote:
> Hello all,
>
> this is a newbie question:
>
> How to increase the precision of calculations in posgresql?
>
> When I run this query:
>
> select 5/2;
>
> I get:
>
> ?column?
> --------
>        2
>
> It should be 2.5 shouldn't it?
>
> Thank you for your time.
>
> Daniel
>
>
>
>
>
>
> _________________________________________________________________
> Help STOP SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=3Dfeatures/junkmail
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster