Subject Re: [firebird-support] Re: problem with round
Author Martijn Tonies

> Thanks for your answer.
> > Dialect 3 follows SQL rules for integer/integer division: the
> result is
> > always rounded down to an integer.
> This seems to me to be a stupid rule, because if I have a non integer
> value as result and assign this to a non integer variable, it should
> not be rounded.
> o.k. if I now, I can pay attention to it in my triggers, but
> nevertheless I find it a stupid rule;-)

SQL standard ;-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions