this works:

select 1.0 / 3.0 * 3.0 from RDB$DATABASE

> -----Original Message-----
> From: PUB: Aage Johansen [mailto:aagjohan@...]
> Sent: Viernes, 30 de Agosto de 2002 15:41
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] 3 * 1/3 = 0 ???
>
>
> Martijn Tonies wrote:
> > > Any chance of changing it next version? If integer
> operations are
> > > desired, how about a div? Please don't tell me that current
> > > behaviour is good. It isn't.
> >
> > Yes it is.
>
> Agree with Martijn.
>
> If you want floating point op's, you can use
> SELECT (cast (1 as float)/3)*3 FROM RDB$DATABASE
> which - in Fb/1 d=3 - returns 1 (in ib_sql) - this should be
> close enough.
>
>
> Regards,
> Aage J.
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> 4 DVDs Free +s&p Join Now
> http://us.click.yahoo.com/pt6YBB/NXiEAA/MVfIAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>