This is standard.

Dividing integer by integer will result in an integer with decimals removed.
You can cast one of the two input values before dividing.

Best regards
Oliver


_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of mariuszstefaniak
Sent: Montag, 28. Juli 2008 13:21
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Divide of an integer values



I'm executing query
select 10 / 3 from rdb$database

On results I have 3 instead 3,3333333333
Without values after comma!

Whats going on? Is this correct? How to force on server normal division
operation?

I have Firebird 2.1.1 and I'm connected to the server by IBExpert.

regards
MS







[Non-text portions of this message have been removed]