From: DI Hasenöhrl <i.hasenoehrl@aon.at>
To: pgsql-odbc@postgresql.org
To: pgsql-sql@postgresql.org
Subject: CAST Problem: Difference between insert a tuple in a table by function and by datasheet
Date: Fri, 22 Jun 2001 14:14:39 +0200
Message-ID: <00b301c0fb14$e98b1da0$01011eac@irina> (raw)
Now,I found the problem, but I don't know how to solve. It depends on type float8.
I changed all type float to float8
In my function I make the following calculation:
.............
update KalkPreislisten_float8 SET kp_ep = rkontingent.k_ep::float8 -- this works correct
but I have to calculate with a numeric type too (rwaehrung.w_euro is numeric(9,5))
....................
update KalkPreislisten_float8 SET kp_ep = rkontingent.k_ep::float8 *rwaehrung.w_euro::float8 -- this doesn't work
Please, can anyone tell me, how I must cast this numeric type to get float8
Many thanks in advance
Irina
E-Mail: i.hasenoehrl@aon.at
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: i.hasenoehrl@aon.at, pgsql-odbc@postgresql.org
Subject: Re: CAST Problem: Difference between insert a tuple in a table by function and by datasheet
In-Reply-To: <00b301c0fb14$e98b1da0$01011eac@irina>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox