Bug #835: round(double precision, integer) function in 7.3 does not work

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #835: round(double precision, integer) function in 7.3 does not work
Date: 2002-12-04 21:26:28
Message-ID: 20021204212628.8910C476247@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Eugene von Niederhausern (evonnied(at)niederworks(dot)com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
round(double precision,integer) function in 7.3 does not work

Long Description
round(double precision,integer) does not work with 7.3. This function did work with 7.2.x.

Sample Code
select round((extract(epoch from CURRENT_TIMESTAMP) - extract(epoch from '2002-12-01'::timestamp))/60.0/60.0/24.0,2); /** does not work with 7.3 **/

select round((extract(epoch from CURRENT_TIMESTAMP) - extract(epoch from '2002-12-01'::timestamp))/60.0/60.0/24.0); /** does work with 7.3 **/

select round(((extract(epoch from CURRENT_TIMESTAMP) - extract(epoch from '2002-12-01'::timestamp))/60.0/60.0/24.0)::numeric,2); /** does work with 7.3 **/

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-12-04 22:55:29 Re: Bug #835: round(double precision, integer) function in 7.3 does not work
Previous Message Bruce Momjian 2002-12-04 18:30:26 Re: List of bugs