| From: | TJ O'Donnell <tjo(at)acm(dot)org> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | SQL error: function round(double precision, integer) does not exist |
| Date: | 2005-02-27 23:26:07 |
| Message-ID: | 4222570F.5080901@acm.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Drake | 2005-02-28 01:55:35 | Re: AutoCommit and DDL |
| Previous Message | Michael Fuhr | 2005-02-27 19:54:34 | Re: AutoCommit and DDL |