On Fri, Aug 6, 2010 at 02:12, Adam Radlowski <ad...@informatyka.gdansk.pl> wrote: > PostgreSQL version: 8.4.4 > Operating system: Gentoo 64 bit (PSQL 8.4.4), Fedora 12 32 bit (PSQL > 8.4.1)
> select round(any_numeric_field*something,2) from any_table; > I get information, that the function dos not exist. Can we get the exact *input* and the error? I cant replicate it here: select round(100::numeric*100, 2); > If I use round(numeric_field*something,int) in "insert" command, round > returns always only the value of "numeric_field". So... insert into table (field) values (round(100*2, 1)) inserts 100? I find that quite hard to believe. Again some actually sql might help here as I might just be misunderstanding. > 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. Sounds like a problem with whatever is generating the SQL not a problem with postgres. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
