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