Received: from erm1.u-strasbg.fr (erm1.u-strasbg.fr [130.79.74.61]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAKFYgs22544 for ; Mon, 20 Nov 2000 10:34:42 -0500 (EST) (envelope-from bboett@erm1.u-strasbg.fr) Received: (qmail 25108 invoked by uid 501); 20 Nov 2000 15:51:33 -0000 Date: Mon, 20 Nov 2000 16:51:33 +0100 From: Bruno Boettcher To: pgsql-sql@postgresql.org Subject: numeric conversions? Message-ID: <20001120165133.D25191@erm1.u-strasbg.fr> Reply-To: bboett@erm1.u-strasbg.fr Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0.1i X-Archive-Number: 200011/153 X-Sequence-Number: 184 Hello, me again :( i just ran into another problem.... didn't found it neither in the doc nor in the FAQ..... the currencies conversion factors i use are stored as float4 in a table, the values to apply on are stores as int4 .... is the type casting done automaticly? how? can i have an influence of the cast order? is there an easy way to doing the rounding? the operation i want to do is something along this line: int4 = ((int4) float4 * (float4)int4 +.5); -- ciao bboett ============================================================== bboett@earthling.net http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett =============================================================== the total amount of intelligence on earth is constant. human population is growing....