pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

Message-ID: <00b301c0fb14$e98b1da0$01011eac@irina>
Permalink:  ../00b301c0fb14$e98b1da0$01011eac@irina/
Also on:    postgresql.org/message-id/00b301c0fb14$e98b1da0$01011eac@irina

 · 

reply

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