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