pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedBug 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