Обсуждение: Bug in CEIL?

Поиск
Список
Период
Сортировка

Bug in CEIL?

От
"Mark Alliban"
Дата:
Is the following normal behaviour? I would have expected a result of 0.
 
 
Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.3 on i586-pc-sco3.2v5.0.4, compiled by gcc 2.7.2.3]
 
   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: template1
 
template1=> select ceil(0);
ceil
----
   1
(1 row)
 
 

Re: [SQL] Bug in CEIL?

От
Tom Lane
Дата:
"Mark Alliban" <MarkA@idnltd.com> writes:
> template1=> select ceil(0);
> ceil
> ----
>    1
> (1 row)

Looks like a bug to me too.  I've just been mucking in the NUMERIC
code, so will put this on my to-do list.

BTW, your mail would be easier for other folks to read if you turned
off all the MIME/HTML junk.
        regards, tom lane