Received: from photon.skillbrokers.bg (root@photon.skillbrokers.bg [195.24.42.194]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA67273 for ; Wed, 19 Jan 2000 09:09:10 -0500 (EST) (envelope-from nmmm@nmmm.nu) Received: from niki (proton.skillbrokers.bg [195.24.42.206]) by photon.skillbrokers.bg (8.9.0/8.9.0) with SMTP id QAA25235; Wed, 19 Jan 2000 16:01:03 +0200 Message-ID: <002101bf6286$419e5b20$ce2a18c3@skillbrokers.bg> From: "Nikolay Mijaylov" To: "Mark Alliban" Cc: "pgsql-general" References: <008c01bf6280$e02d8a00$c80110ac@centauri> Subject: Re: [SQL] Bug in CEIL? Date: Wed, 19 Jan 2000 16:05:33 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001E_01BF6297.041A9D20" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 This is a multi-part message in MIME format. ------=_NextPart_000_001E_01BF6297.041A9D20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable PostgreSQL 6.4.2 : --------------------- Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL 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: root root=3D> select ceil(0); ERROR: No such function 'ceil' with the specified attributes -------------------------------------------------------------- nmmm -------------------------------------------------------------- The reboots are for hardware upgrades! "www.nmmm.nu"; ----- Original Message -----=20 From: Mark Alliban=20 To: pgsql-sql@postgreSQL.org=20 Sent: =F1=F0=FF=E4=E0, =DF=ED=F3=E0=F0=E8 19, 2000 03:26 Subject: [SQL] Bug in CEIL? Is the following normal behaviour? I would have expected a result of = 0. =20 =20 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) =20 =20 ------=_NextPart_000_001E_01BF6297.041A9D20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
PostgreSQL 6.4.2 :
---------------------
Welcome to the POSTGRESQL interactive sql = monitor:
 =20 Please read the file COPYRIGHT for copyright terms of = POSTGRESQL
 
   type \? for help on slash=20 commands
   type \q to quit
   type \g or = terminate=20 with semicolon to execute query
 You are currently connected to = the=20 database: root
 
root=3D> select ceil(0);
ERROR:  No such = function=20 'ceil' with the specified attributes
 
--------------------------------------------------------------nmmm
--------------------------------------------------------------
Th= e=20 reboots are for hardware upgrades!
"www.nmmm.nu"; <nmmm@nmmm.nu>
 
 
----- Original Message -----
From:=20 Mark = Alliban=20
To: pgsql-sql@postgreSQL.org
Sent: =F1=F0=FF=E4=E0, = =DF=ED=F3=E0=F0=E8 19, 2000 03:26
Subject: [SQL] Bug in = CEIL?

Is the following = normal behaviour?=20 I would have expected a result of 0.
 
 
Welcome to the=20 POSTGRESQL interactive sql monitor:
  Please read the file = COPYRIGHT=20 for copyright terms of POSTGRESQL
[PostgreSQL 6.5.3 on=20 i586-pc-sco3.2v5.0.4, 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_001E_01BF6297.041A9D20--