Received: from relay5.ftech.net (littleblue.ftech.net [195.200.12.27]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA55144 for ; Wed, 19 Jan 2000 08:26:30 -0500 (EST) (envelope-from MarkA@idnltd.com) Received: from ibm9.ftech.net ([212.32.16.79] helo=idnltd.com) by relay5.ftech.net with smtp (Exim 3.12.ftech-p6 #1) id 12Av7w-0006BW-01 for pgsql-sql@postgresql.org; Wed, 19 Jan 2000 13:26:25 +0000 Message-ID: <008c01bf6280$e02d8a00$c80110ac@centauri> From: "Mark Alliban" To: Subject: Bug in CEIL? Date: Wed, 19 Jan 2000 13:26:56 -0000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0089_01BF6280.DBEC0FC0" 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_0089_01BF6280.DBEC0FC0 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] =20 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 =20 template1=3D> select ceil(0); ceil ---- 1 (1 row) ------=_NextPart_000_0089_01BF6280.DBEC0FC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Is the following normal = behaviour? I=20 would have expected a result of 0.
 
 
Welcome to the=20 POSTGRESQL interactive sql monitor:
  Please read the file = COPYRIGHT for=20 copyright terms of POSTGRESQL
[PostgreSQL 6.5.3 on = i586-pc-sco3.2v5.0.4,=20 compiled by 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_0089_01BF6280.DBEC0FC0--