> is the type casting done automaticly? how? can i have an influence of
> the cast order? is there an easy way to doing the rounding?
bf2=# select 1 / 2 from dual;
?column?
----------
0
(1 row)
bf2=# select 1::float / 2 from dual;
?column?
----------
0.5
(1 row)
bf2=# select (1::float / 2)::int from dual;
?column?
----------
0
(1 row)
Also you have the functions round, floor, and ceil, which do what you would
expect.
-Jonathan