[GENERAL] Re: [SQL] Bug in CEIL?

2000-01-19 Thread Nikolay Mijaylov 



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 queryYou 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"; [EMAIL PROTECTED]



  - Original Message - 
  From: 
  Mark Alliban 
  
  To: [EMAIL PROTECTED] 
  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 queryYou are currently connected 
  to the database: template1
  
  template1= select 
  ceil(0);ceil 1(1 row)

Re: [GENERAL] Re: [SQL] Bug in CEIL?

2000-01-19 Thread Bruce Momjian 

[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
  [EMAIL PROTECTED]   |  (610) 853-3000
  +  If your life is a hard drive, |  830 Blythe Avenue
  +  Christ can be your backup.|  Drexel Hill, Pennsylvania 19026