BUG #5605: round(attr_name,int) works bad

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.

Responses

Browse pgsql-bugs by date

  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