Received: from relay4.ftech.net (status.ftech.net [195.200.0.89]) by hub.org (8.9.3/8.9.3) with ESMTP id HAA37268 for ; Wed, 19 Jan 2000 07:28:58 -0500 (EST) (envelope-from MarkA@idnltd.com) Received: from ibm9.ftech.net ([212.32.16.79] helo=idnltd.com) by relay4.ftech.net with smtp (Exim 3.12.ftech-p6 #1) id 12AuEF-0005Qg-00 for pgsql-sql@postgresql.org; Wed, 19 Jan 2000 12:28:51 +0000 Message-ID: <006001bf6276$a207daf0$c80110ac@centauri> From: "Mark Alliban" To: Subject: Bug in CEIL? Date: Wed, 19 Jan 2000 12:13:43 -0000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005D_01BF6276.A11F9DD0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.2110.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 This is a multi-part message in MIME format. ------=_NextPart_000_005D_01BF6276.A11F9DD0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=3D> select ceil(0); ceil ---- 1 (1 row) ------=_NextPart_000_005D_01BF6276.A11F9DD0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Is the=20 following normal behaviour? I would have expected a result of = 0.
 
 
Welcome to the = POSTGRESQL=20 interactive sql monitor:
  Please read the file COPYRIGHT for = copyright=20 terms of POSTGRESQL
[PostgreSQL 6.5.3 on i586-pc-sco3.2v5.0.4, = compiled by=20 gcc 2.7.2.3]
 
   type \? = for help on=20 slash commands
   type \q to quit
   type \g = or=20 terminate with semicolon to execute query
 You are currently = connected=20 to the database: template1
 
template1=3D> = select=20 ceil(0);
ceil
----
   1
(1 row)
 
------=_NextPart_000_005D_01BF6276.A11F9DD0--