Thread: float and numeric in 7.3

float and numeric in 7.3

From
Tomasz Myrta
Date:
Hi

I've just upgraded Postgresql 7.2 -> 7.3

Some of my views use function "round" with datatype "float".
They don't work after upgrading:

ERROR:  Function round(double precision, integer) does not exist

What happened? 
7.3 can't automaticaly cast float into numeric? 
Or maybe 7.2 had both functions round(numeric, integer) andround(double precision, integer)?

Should I change float into numeric in my tables if possible?

Regards,
Tomasz Myrta



Re: float and numeric in 7.3

From
Tom Lane
Date:
Tomasz Myrta <jasiek@klaster.net> writes:
> 7.3 can't automaticaly cast float into numeric? 

Nope, we tightened it up --- that's not an implicit cast anymore.
        regards, tom lane