[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: [GENERAL] ERROR: function round(double precision, integer) does not exist - WTF?
From: "Glen Parker" <glenebob () nwlink ! com>
Date: 2004-03-05 1:08:35
Message-ID: 000901c4024e$63bbe760$0b01a8c0 () saturn
[Download RAW message or body]
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@nwlink.com
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic