From: | "Adam Radlowski" <adamr(at)informatyka(dot)gdansk(dot)pl> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5605: round(attr_name,int) works bad |
Date: | 2010-08-06 08:12:08 |
Message-ID: | 201008060812.o768C8BR085657@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5605
Logged by: Adam Radlowski
Email address: adamr(at)informatyka(dot)gdansk(dot)pl
PostgreSQL version: 8.4.4
Operating system: Gentoo 64 bit (PSQL 8.4.4), Fedora 12 32 bit (PSQL
8.4.1)
Description: round(attr_name,int) works bad
Details:
On both systems simmilar problems:
PSQL 8.4.4 (taken from "www.postgresql.org" and compiled on 64 bit latest
Gentoo)
PSQL 8.4.1 (from Fedora 12 distribution disk):
If I try for example:
select round(any_numeric_field*something,2) from any_table;
I get information, that the function dos not exist.
If I use round(numeric_field*something,int) in "insert" command, round
returns always only the value of "numeric_field".
Comment:
In some cases I can use for example:
select round(100.0*any_numeric_field)/100.0 from any_table;
..but in programs wchich are generating SQL code and I can't modify them it
is important problem.
From | Date | Subject | |
---|---|---|---|
Next Message | Chris | 2010-08-06 08:14:19 | Re: BUG #5602: Recovering from Hot-Standby file backup leads to the currupted indexes |
Previous Message | Fujii Masao | 2010-08-06 06:16:08 | Re: In 8.2, shutdown wrongly caused automatic restart |