оЕПЕЯШКЙЮ: What should be the output of ceiling?

["Shulzhenko Vasyl" <vasilis@softline.kiev.ua>]

-----хЯУНДМНЕ ЯННАЫЕМХЕ-----
нР: Art S. Kagel <kagel@bloomberg.net>
цПСООШ: comp.databases.informix
йНЛС: Girish Kagrana <girishk@infogain.com>
дЮРЮ: 27 ЪМБЮПЪ 1999 Ц. 23:57
рЕЛЮ: Re: What should be the output of ceiling?


>Girish Kagrana wrote:
>>
>> What should be the output of ceiling?
>>
>> Here is some comparison on Informix(7.30 UC3)/Oracle/SQLServer
>>
>> Select stmt used 'SELECT CEILING (ip_value) .'
>>
>> Database      ip_value  op_value
>> -----------   --------    ------------
>> Informix      10            11
>> Oracle        10            10
>> SQLServer     10            10
>>
>> Informix      10.0          11
>> Orac          10.0          10
>> SQLServer     10.0          10
>>
>> Informix      10.1          11
>> Oracle        10.1          11
>> SQLServer     10.1          11
>>
>> For last set i.e. when ip_value is 10.1 o/p is same for all the databases,
>> then why is the first two result sets different in Informix,  is this Bug
>> in Informix or  is it the correct o/p of ceiling?
>
>Looks like you have a bug report Girish.  Ceiling is supposed to
>parallel the "C" ceil and ceilf functions which are defined to return
>"the smallest integer not smaller than" their argument.
>
>Art S. Kagel