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 01:08:35
Message-ID: 000901c4024e$63bbe760$0b01a8c0@saturn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm having trouble with the round() function. What I am trying to do works
fine on 7.2.*, but not in 7.3.* or 7.4.*

DB=# select version();
PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2
20031107 (Red Hat Linux 3.3.2-2)

DB=# select round(1.25::float);
round
-------
1
(1 row)

oms=# select round(1.25::decimal, 2);
round
-------
1.25
(1 row)

BUT.............

DB=# select round(1.25::float, 2);
ERROR: function round(double precision, integer) does not exist
HINT: No function matches the given name and argument types. You may need
to add explicit type casts.

What the heck? This can't be right... Can it?

Thx!
Glen Parker
glenebob(at)nwlink(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-03-05 01:25:38 Re: ERROR: function round(double precision, integer) does
Previous Message DeJuan Jackson 2004-03-05 00:48:33 Tom Lane heads up