Received: from chemquick.com (root@[202.170.29.67]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA09938 for ; Mon, 14 Jun 1999 11:21:42 -0400 (EDT) (envelope-from vikrant@chemquick.com) Received: from chemquick.com ([202.170.29.126]) by chemquick.com (8.8.7/8.8.7) with ESMTP id XAA15652 for ; Mon, 14 Jun 1999 23:15:15 +0800 Message-ID: <376520B4.25769FE@chemquick.com> Date: Mon, 14 Jun 1999 23:33:08 +0800 From: Vikrant Rathore Reply-To: vikrant@chemquick.com Organization: NeuroNet X-Mailer: Mozilla 4.6 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Mail about typecast Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I want to do a following operation on the timespan select overdue * date_part('epoch',usage)::float4 from indusevar; where overdue is of type float4 and i want to typecast date_part('epoch',usage) to float4 since dat_part(text,timespan) returns a float8 type. Whenever I try to typecast it gives an error 'function dtof(float8) does not exist'. Can anyone help me to solve the problem. Thanks in advance for your valuable advice. Waiting for a response. Regards, Vicky