Postgres Pro
Downloads
Home   >   mailing lists

Bug in CEIL? - Mailing list pgsql-sql

From Mark Alliban
Subject Bug in CEIL?
Date
Msg-id 008c01bf6280$e02d8a00$c80110ac@centauri
Whole thread Raw
Responses Re: [SQL] Bug in CEIL?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view
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-sql by date:

Previous
From: "Mark Alliban"
Date:
Subject: Bug in CEIL?
Next
From: Jose Soares
Date:
Subject: Re: [SQL] char(19) to varchar(32)