| From: | Vikrant Rathore <vikrant(at)chemquick(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Mail about typecast |
| Date: | 1999-06-14 15:33:08 |
| Message-ID: | 376520B4.25769FE@chemquick.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I want to do a following operation on the timespan
select overdue * date_part('epoch',usage)::float4 from indusevar;
where overdue is of type float4 and i want to typecast
date_part('epoch',usage) to float4 since dat_part(text,timespan) returns
a float8 type.
Whenever I try to typecast it gives an error 'function dtof(float8)
does not exist'. Can anyone help me to solve the problem.
Thanks in advance for your valuable advice.
Waiting for a response.
Regards,
Vicky
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael J Davis | 1999-06-14 19:03:48 | RE: [GENERAL] Two variable passed to PL/Function and on is NULL |
| Previous Message | Georg Ritter | 1999-06-13 21:56:39 | backing up a db, jdbc, SQL syntax, etc... |