Received: from aeolus.geo.umass.edu (aeolus.geo.umass.edu [128.119.45.25]) by hub.org (8.8.8/8.7.5) with ESMTP id PAA12455 for ; Thu, 18 Jun 1998 15:35:13 -0400 (EDT) Received: (from wdmccoy@localhost) by aeolus.geo.umass.edu (8.8.4/8.6.9) id PAA11821; Thu, 18 Jun 1998 15:33:04 -0400 (EDT) Date: Thu, 18 Jun 1998 15:33:04 -0400 (EDT) Message-Id: <199806181933.PAA11821@aeolus.geo.umass.edu> From: "William D. McCoy" MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit To: pgsql-sql@postgreSQL.org Subject: converting float4 to float8 X-Mailer: VM 6.34 under 20.3 "Vatican City" XEmacs Lucid I'm trying to get a query to return a float8 for a field defined as float4. When I use select cast(attname as float8) from table1; I get the error: ERROR: function ftod(float4) does not exist Any ideas how I can do this? I'm trying to use this select in an "insert into" statement where the target table needs to have the target field defined as float8. -- William D. McCoy Geosciences University of Massachusetts Amherst, MA 01003