By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,610 Members | 1,041 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,610 IT Pros & Developers. It's quick & easy.

ERROR: function round(double precision, integer) does not exist - WTF?

P: n/a
> I think in 7.2 such conversions were allowed silently, but we
have reduced the number of implicit type coercions.


I'm sensing some brain damage going on here...

DB=# select round(100::int, 2);
round
--------
100.00
(1 row)

And...

DB=# create temp table test2(field1 float, field2 decimal);
CREATE TABLE DB=# insert into test2 values(1,1); INSERT
32200009 1 DB=# update test2 set field1=field2 field2=field1; UPDATE 1

So the coercions work fine most of the time. I still say
it's broken :-)

Glen Parker
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.