Re: [SQL] Bug in CEIL? - Mailing list pgsql-general

From Nikolay Mijaylov
Subject Re: [SQL] Bug in CEIL?
Date
Msg-id 002101bf6286$419e5b20$ce2a18c3@skillbrokers.bg
Whole thread Raw
Responses Re: [GENERAL] Re: [SQL] Bug in CEIL?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
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
 
--------------------------------------------------------------
nmmm
--------------------------------------------------------------
The reboots are for hardware upgrades!
"www.nmmm.nu"; <nmmm@nmmm.nu>
 
 
----- Original Message -----
Sent: ñðÿäà, ßíóàðè 19, 2000 03:26
Subject: [SQL] Bug in CEIL?

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=> select ceil(0);
ceil
----
   1
(1 row)
 
 

pgsql-general by date:

Previous
From: Martin Neumann
Date:
Subject: Unsigned Datatypes
Next
From: Gabriel Fernandez
Date:
Subject: Problems with operator '%' within a select