Re: [SQL] Bug in CEIL?

From: "Nikolay Mijaylov" <nmmm(at)nmmm(dot)nu>
To: "Mark Alliban" <MarkA(at)idnltd(dot)com>
Cc: "pgsql-general" <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [SQL] Bug in CEIL?
Date: 2000-01-19 14:05:33
Message-ID: 002101bf6286$419e5b20$ce2a18c3@skillbrokers.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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(at)nmmm(dot)nu>

----- Original Message -----
From: Mark Alliban
To: pgsql-sql(at)postgreSQL(dot)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)


In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gabriel Fernandez 2000-01-19 14:35:58 Problems with operator '%' within a select
Previous Message Mark Alliban 2000-01-19 13:26:56 Bug in CEIL?

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-01-19 15:02:13 Re: [SQL] Bug in CEIL?
Previous Message Jose Soares 2000-01-19 14:01:37 Re: [SQL] char(19) to varchar(32)