How to increase precision?

From: "Katka a Daniel Dunajsky" <daniel_katka(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to increase precision?
Date: 2003-05-02 21:38:21
Message-ID: Law12-F72YKpDS7hx2700007b3c@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kyle 2003-05-02 22:06:40 Best way to delete time stamped data?
Previous Message Chris Gamache 2003-05-02 20:46:54 Re: What is bad in this query ?