Re: select 5/2???

>
> 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