[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] ERROR:  function round(double precision, integer) does
From:       "Joshua D. Drake" <jd () commandprompt ! com>
Date:       2004-03-05 1:25:38
Message-ID: 4047D712.5020200 () commandprompt ! com
[Download RAW message or body]

> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]