Bug #835: round(double precision,integer) function in 7.3 does not work
| От | pgsql-bugs@postgresql.org |
|---|---|
| Тема | Bug #835: round(double precision,integer) function in 7.3 does not work |
| Дата | |
| Msg-id | 20021204212628.8910C476247@postgresql.org обсуждение исходный текст |
| Ответы |
Re: Bug #835: round(double precision,integer) function in 7.3 does not work
Re: List of Bugs |
| Список | 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 по дате отправления: