Re: ERROR: function round(double precision, integer) does

> oms=# select round(1.25::decimal, 2);
> round
> -------
> 1.25
> (1 row)
>
> BUT.............
>
> DB=# select round(1.25::float, 2);

select round(1.25::numeric, 2);

?

Sincerely,

Joshua D. Drake

> 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
>
>
>
>
> ---------------------------(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