From: | DI Hasenöhrl <i(dot)hasenoehrl(at)aon(dot)at> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | CAST Problem: Difference between insert a tuple in a table by function and by datasheet |
Date: | 2001-06-22 12:14:39 |
Message-ID: | 00b301c0fb14$e98b1da0$01011eac@irina |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc pgsql-sql |
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(dot)hasenoehrl(at)aon(dot)at
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2001-06-22 16:08:25 | Re: Difference between insert a tuple in a table by function and by datasheet |
Previous Message | Dariusz Pietrzak | 2001-06-22 10:15:09 | RE: RE: Difference between insert by a function and per ha nd |
From | Date | Subject | |
---|---|---|---|
Next Message | Kristoff Bonne | 2001-06-22 12:51:28 | What is a "tuple" |
Previous Message | Markus Bertheau | 2001-06-22 12:06:32 | select tbl1.attr1, number of tuples where tbl2.attr1=tbl1.attr1 |