Mail about typecast

From: Vikrant Rathore <vikrant(at)chemquick(dot)com>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Mail about typecast
Date: 1999-06-15 03:17:08
Message-ID: 3765C5B3.C05DC56D@chemquick.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-sql

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.

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Sergio Perez 1999-06-15 08:17:55 problems with pgaccess 0.93 and postgres 6.3
Previous Message Ken Plumbly 1999-06-15 02:56:07 order by in c (libpq)?

Browse pgsql-sql by date

  From Date Subject
Next Message Fomichev Michael 1999-06-15 03:38:01 Re: [ADMIN] Apache authentication & PostgreSQL
Previous Message Tom Lane 1999-06-14 21:20:38 Re: [SQL] RE: [GENERAL] Two variable passed to PL/Function and on is NULL