Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA81008 for ; Wed, 19 Jan 2000 10:02:16 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id KAA09790; Wed, 19 Jan 2000 10:02:13 -0500 (EST) To: "Mark Alliban" cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Bug in CEIL? In-reply-to: <008c01bf6280$e02d8a00$c80110ac@centauri> References: <008c01bf6280$e02d8a00$c80110ac@centauri> Comments: In-reply-to "Mark Alliban" message dated "Wed, 19 Jan 2000 13:26:56 +0000" Date: Wed, 19 Jan 2000 10:02:13 -0500 Message-ID: <9787.948294133@sss.pgh.pa.us> From: Tom Lane "Mark Alliban" 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