pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Bug in CEIL?
5+ messages / 4 participants
[nested] [flat]

* Bug in CEIL?
@ 2000-01-19 12:13 Mark Alliban <MarkA@idnltd.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Mark Alliban @ 2000-01-19 12:13 UTC (permalink / raw)
  To: pgsql-sql

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)

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Bug in CEIL?
@ 2000-01-19 13:26 Mark Alliban <MarkA@idnltd.com>
  2000-01-19 14:05 ` Re: [SQL] Bug in CEIL? Nikolay Mijaylov <nmmm@nmmm.nu>
  2000-01-19 15:02 ` Re: [SQL] Bug in CEIL? Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 5+ messages in thread

From: Mark Alliban @ 2000-01-19 13:26 UTC (permalink / raw)
  To: pgsql-sql

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)

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [SQL] Bug in CEIL?
  2000-01-19 13:26 Bug in CEIL? Mark Alliban <MarkA@idnltd.com>
@ 2000-01-19 14:05 ` Nikolay Mijaylov <nmmm@nmmm.nu>
  2000-01-19 17:07   ` Re: [GENERAL] Re: [SQL] Bug in CEIL? Bruce Momjian <pgman@candle.pha.pa.us>
  1 sibling, 1 reply; 5+ messages in thread

From: Nikolay Mijaylov @ 2000-01-19 14:05 UTC (permalink / raw)
  To: Mark Alliban <MarkA@idnltd.com>; +Cc: pgsql-general <pgsql-general@postgreSQL.org>

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 ----- 
  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)
   
   

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [GENERAL] Re: [SQL] Bug in CEIL?
  2000-01-19 13:26 Bug in CEIL? Mark Alliban <MarkA@idnltd.com>
  2000-01-19 14:05 ` Re: [SQL] Bug in CEIL? Nikolay Mijaylov <nmmm@nmmm.nu>
@ 2000-01-19 17:07   ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 5+ messages in thread

From: Bruce Momjian @ 2000-01-19 17:07 UTC (permalink / raw)
  To: Nikolay Mijaylov <nmmm@nmmm.nu>; +Cc: Mark Alliban <MarkA@idnltd.com>; pgsql-general <pgsql-general@postgreSQL.org>

[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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [SQL] Bug in CEIL?
  2000-01-19 13:26 Bug in CEIL? Mark Alliban <MarkA@idnltd.com>
@ 2000-01-19 15:02 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 5+ messages in thread

From: Tom Lane @ 2000-01-19 15:02 UTC (permalink / raw)
  To: Mark Alliban <MarkA@idnltd.com>; +Cc: pgsql-sql

"Mark Alliban" <MarkA@idnltd.com> writes:
> template1=> select ceil(0);
> ceil
> ----
>    1
> (1 row)

Looks like a bug to me too.  I've just been mucking in the NUMERIC
code, so will put this on my to-do list.

BTW, your mail would be easier for other folks to read if you turned
off all the MIME/HTML junk.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2000-01-19 17:07 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-19 12:13 Bug in CEIL? Mark Alliban <MarkA@idnltd.com>
2000-01-19 13:26 Bug in CEIL? Mark Alliban <MarkA@idnltd.com>
2000-01-19 14:05 ` Nikolay Mijaylov <nmmm@nmmm.nu>
2000-01-19 17:07   ` Bruce Momjian <pgman@candle.pha.pa.us>
2000-01-19 15:02 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox