Received: from acc0.visti.net (acc0.visti.net [195.64.225.233]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA09207 for ; Wed, 9 Jun 1999 11:44:04 -0400 (EDT) (envelope-from ssr@visti.net) Received: from office.visti.net (office.visti.net [195.64.225.183]) by acc0.visti.net (8.8.8-Elvisti-980428/8.8.8) with ESMTP id SAA08922 for ; Wed, 9 Jun 1999 18:43:59 +0300 (EEST) Received: from visti.net (angel.visti.net [195.64.225.244]) by office.visti.net (8.6.12/8.ElVisti) with ESMTP id SAA06374 for ; Wed, 9 Jun 1999 18:43:59 +0300 Sender: ssr@visti.net Message-ID: <375E8C0D.1A8B5FDD@visti.net> Date: Wed, 09 Jun 1999 18:45:17 +0300 From: "Sergey S. Rakitin" Reply-To: ssr@visti.net Organization: ElVisti IC X-Mailer: Mozilla 4.6 [ru] (X11; I; FreeBSD 3.2-19990530-STABLE i386) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: fields with float[48] type question Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit Hi, I have two pc's with PostgreSQL 6.4.2r and 6.5beta2 and some troubles with both of them. Well, here's an example: I create some simple table with float field (called field_one), insert value 100 in it. Then I need to increase/decrease it number by 0.06 on every step many times (from trigger/SPI or simple shell script contains just _21_ (or less) lines like this: 'update set field_one = field_one [-+] 0.06')... Here'we go. If I put _22+_ lines I got very interesting results. For example: 100 - 22 times by 0.06 == 98.6799999999999 instead of 98.68... And it's not the end of story... Can someone explain me such behaviour?.. -- Sergey S. Rakitin ElVisti SSR2-RIPE Information Center