Mail about typecast
| От | Vikrant Rathore |
|---|---|
| Тема | Mail about typecast |
| Дата | |
| Msg-id | 3765C5B3.C05DC56D@chemquick.com обсуждение исходный текст |
| Ответы |
Re: [SQL] Mail about typecast
|
| Список | 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.
В списке pgsql-sql по дате отправления: