From: Katka a Daniel Dunajsky <daniel_katka@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: How to increase precision?
Date: Fri, 02 May 2003 15:38:21 -0600
Message-ID: <Law12-F72YKpDS7hx2700007b3c@hotmail.com> (raw)
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=features/junkmail
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: daniel_katka@hotmail.com
Subject: Re: How to increase precision?
In-Reply-To: <Law12-F72YKpDS7hx2700007b3c@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox