How to increase precision? - Mailing list 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