Thread: Re: [SQL] Bug in CEIL?

----- Original Message -----

From: Mark Alliban

To: pgsql-sql@postgreSQL.org

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)

 

 

[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