From: | José Soares <jose(at)sferacarta(dot)com> |
---|---|
To: | vikrant(at)chemquick(dot)com |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [SQL] Mail about typecast |
Date: | 1999-06-15 12:42:03 |
Message-ID: | 37664A1B.D0BF946@sferacarta.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-sql |
Vikrant Rathore ha scritto:
> 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.
Which version of PostgreSQL are you using?
This works for me. (v6.5)
hygea=> \df dtof
result|function|arguments|description
------+--------+---------+------------------------
float4|dtof |float8 |convert float8 to float4
(1 row)
hygea=> select date_part('epoch','12 hours'::timespan)::float4;
float4
------
43200
(1 row)
hygea=> select date_part('epoch','12 hours'::timespan);
date_part
---------
43200
(1 row)
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'
From | Date | Subject | |
---|---|---|---|
Next Message | StOo | 1999-06-15 13:15:17 | psql command access through libpq/libpq++ |
Previous Message | Sergio Perez | 1999-06-15 08:17:55 | problems with pgaccess 0.93 and postgres 6.3 |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-06-15 13:39:56 | Re: [SQL] Mail about typecast |
Previous Message | Alexander Schneider | 1999-06-15 12:21:03 | FullTextIndex Problems on Update |