select 2500 / 1000 Result = 2 ?

[ahmet_sinav]

hi all
i am making some calculations in my function like below
Code:

select x / t from tbl_q;
x = 2500 t=1000
Result = 2

its turning me 2 but i want 2.5
how can i solve this problem can u show me the way?
pg 8.2.4 platform windows.
Best Regards..

 

[stefanwagner]

are x and t integers?

select (x*1.0/t*1.0)

would generate floating point numbers, and divide that, thus resulting in a fp result.

don't visit my homepage:

http://home.arcor.de/hirnstrom/bewerbung

 

[ahmet_sinav]

select (x/t)::number(15,2) from tbl_q;
is working true;
and your solution is working too.
tnks..