The following bug has been logged online: Bug reference: 5605 Logged by: Adam Radlowski Email address: ad...@informatyka.gdansk.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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
