Bug #835: round(double precision,integer) function in 7.3 does not work - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #835: round(double precision,integer) function in 7.3 does not work
Date
Msg-id 20021204212628.8910C476247@postgresql.org
Whole thread Raw
Responses Re: Bug #835: round(double precision,integer) function in 7.3 does not work
Re: List of Bugs
List pgsql-bugs
Eugene von Niederhausern (evonnied@niederworks.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); /**
doeswork 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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: List of bugs
Next
From: Tom Lane
Date:
Subject: Re: Bug #835: round(double precision,integer) function in 7.3 does not work