> > I run select 5/2 = 2 > who to get "2.5" > integer/integer = integer float/integer = float integer/float = float integer/integer::float = float
test=# SELECT 5.0/2;
?column?
----------
2.5
(1 row)
test=# SELECT 5/2::float;
?column?
----------
2.5
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
