the round sintax is round(numeric,int) not round (double,int)
you must cast the value into numeric: ex: round (cast(doublecolumn as numeric),2) should work ok
Adrian Din, Om Computer & SoftWare
On Sun, 27 Feb 2005 15:26:07 -0800, TJ O'Donnell <[EMAIL PROTECTED]> wrote:
I received the following error when executing a SQL statement:
SQL error: ERROR: function round(double precision, integer) does not exist
In statement:
select id,smiles,smarts,parameter,oe_count_matches(smiles,smarts) as count,
round((parameter*oe_count_matches(smiles,smarts)),2) as psa,tpsa(smiles) as ctpsa,tpsa
from structure,tpsa
where id < 237610
and oe_count_matches(smiles,smarts) > 0
order by id;
The functions described at: http://www.postgresql.org/docs/7.4/static/functions-math.html show that round(numeric,int) should work ok. If I use round() without a second argument, it works OK, but this gives a loss of precision which I do not want.
Can anyone help me with this?
Thanks, TJ
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
-- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
