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-14 15:33:08
Message-ID: 376520B4.25769FE@chemquick.com
Views: Raw Message | Whole Thread | 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

Browse pgsql-sql by date

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