X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DE0DE475CA9 for ; Mon, 3 Feb 2003 14:31:31 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id 93B9B475925 for ; Mon, 3 Feb 2003 14:31:14 -0500 (EST) Received: from klaster.net (pi103.krakow.cvx.ppp.tpnet.pl [217.99.209.103]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 033B82B85D for ; Mon, 3 Feb 2003 20:24:48 +0100 (CET) Message-ID: <3E3EC4AD.8080205@klaster.net> Date: Mon, 03 Feb 2003 20:36:13 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: "'pgsql-sql@postgresql.org'" Subject: float and numeric in 7.3 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/67 X-Sequence-Number: 11465 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