From MarkA@idnltd.com Wed Jan 19 12:28:58 2000 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-- From MarkA@idnltd.com Wed Jan 19 13:26:30 2000 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-- From nmmm@nmmm.nu Wed Jan 19 14:09:10 2000 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-- From tgl@sss.pgh.pa.us Wed Jan 19 15:02:16 2000 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 From pgman@candle.pha.pa.us Wed Jan 19 17:09:34 2000 Received: from candle.pha.pa.us (pgman@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA28704 for ; Wed, 19 Jan 2000 12:09:34 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id MAA08625; Wed, 19 Jan 2000 12:07:15 -0500 (EST) From: Bruce Momjian Message-Id: <200001191707.MAA08625@candle.pha.pa.us> Subject: Re: [GENERAL] Re: [SQL] Bug in CEIL? In-Reply-To: <002101bf6286$419e5b20$ce2a18c3@skillbrokers.bg> from Nikolay Mijaylov at "Jan 19, 2000 04:05:33 pm" To: Nikolay Mijaylov Date: Wed, 19 Jan 2000 12:07:15 -0500 (EST) CC: Mark Alliban , pgsql-general X-Mailer: ELM [version 2.4ME+ PL66 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit [Charset iso-8859-1 unsupported, filtering to ASCII...] > 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=> select ceil(0); > ERROR: No such function 'ceil' with the specified attributes Current sources show: test=> select ceil(0); ceil ------ 1 (1 row) -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026