Received: from huey.jpl.nasa.gov (huey.jpl.nasa.gov [128.149.68.100]) by hub.org (8.10.1/8.10.1) with ESMTP id e6AEKXW90976 for ; Mon, 10 Jul 2000 10:20:33 -0400 (EDT) Received: from golem.jpl.nasa.gov (hectic-1 [128.149.68.203]) by huey.jpl.nasa.gov (8.8.8+Sun/8.8.8) with ESMTP id HAA21944; Mon, 10 Jul 2000 07:20:20 -0700 (PDT) Received: from alumni.caltech.edu (localhost.localdomain [127.0.0.1]) by golem.jpl.nasa.gov (Postfix) with ESMTP id 5FAD86F4F; Mon, 10 Jul 2000 14:24:32 +0000 (UTC) Message-ID: <3969DCA0.25B4783E@alumni.caltech.edu> Date: Mon, 10 Jul 2000 14:24:32 +0000 From: Thomas Lockhart Organization: Yes X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14-15mdksmp i686) X-Accept-Language: en MIME-Version: 1.0 To: Ice Planet Cc: pgsql-sql@postgresql.org Subject: Re: Type conversion References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/98 > select TheNumberFromConsole/(select max(division_point) from table1) Try select '1234.5678'/(select max(division_point) from table1); The quotes around the apparent floating point number keeps Postgres from assuming that it *is* a floating point number, and it later decides that it must have been a numeric() type. - Thomas