Thread: Bug in CEIL?
Is the following normal behaviour? I would have expected a result of 0.
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
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)
ceil
----
1
(1 row)
"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