float and numeric in 7.3

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: float and numeric in 7.3
Date: 2003-02-03 19:36:13
Message-ID: 3E3EC4AD.8080205@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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) and
round(double precision, integer)?

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

Regards,
Tomasz Myrta

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Les Hazlewood 2003-02-03 21:36:15 SQL99/SQL92 Grammar
Previous Message Robert Treat 2003-02-03 19:17:04 Re: Server access thru webmin