Eugene von Niederhausern ([EMAIL PROTECTED]) 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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to