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.
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)? |
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 |