Postgres Pro
Downloads
Home   >   mailing lists

How to increase precision? - Mailing list pgsql-sql

From Katka a Daniel Dunajsky
Subject How to increase precision?
Date
Msg-id Law12-F72YKpDS7hx2700007b3c@hotmail.com
Whole thread Raw
Responses Re: How to increase precision?  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: How to increase precision?  (Josh Berkus <josh@agliodbs.com>)
Re: How to increase precision?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Chris Gamache
Date:
Subject: Re: What is bad in this query ?
Next
From: Kyle
Date:
Subject: Best way to delete time stamped data?