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

From: "Glen Parker" <glenebob(at)nwlink(dot)com>
To: "Pg-General" <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: function round(double precision, integer) does not exist - WTF?
Date: 2004-03-05 02:52:45
Message-ID: 001b01c4025c$efcddf70$0b01a8c0@saturn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-03-05 03:40:11 Re: ERROR: function round(double precision, integer) does
Previous Message Karl O. Pinc 2004-03-05 02:39:04 Re: REFERENCES error message complaint, suggestion