Message-ID: <3765C5B3.C05DC56D@chemquick.com>
Date: Tue, 15 Jun 1999 11:17:08 +0800
From: Vikrant Rathore <vikrant@chemquick.com>
Reply-To: vikrant@chemquick.com
Organization: NeuroNet
MIME-Version: 1.0
To: pgsql-sql@postgreSQL.org
Subject: Mail about typecast
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Dear friends,

    I want to run a query :

vikrant=> select date_part('epoch','12 hours'::timespan)::float4;
It returns a error message
ERROR:  function dtof(float8) does not exist

But i want to use typecast since the result of this query will be used
to update a field of type float4.

I have checked the pg_proc system table it has a function dtof with
float8 as argument i have checked the list of functions also and
'dtof(float8)' is shown in that list also.
can anyone solve this problem. I can solve the problem by using a c
program but i want to know when the function dtof(float8) is there in
pg_proc table then why it is not doing a typecasting.
Thanks in advance for your kind suggestion.

Thanks & regards,
Vikrant.