Received: from mail-b.bcc.ac.uk (mail-b.bcc.ac.uk [144.82.100.22]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA98367 for ; Thu, 10 Jun 1999 04:58:48 -0400 (EDT) (envelope-from stuart@ludwig.ucl.ac.uk) Received: from kestrel.ludwig.ucl.ac.uk by mail-b.bcc.ac.uk with SMTP (XT-PP); Thu, 10 Jun 1999 09:58:03 +0100 Received: from [128.40.242.190] by kestrel.ludwig.ucl.ac.uk (SMI-8.6/SMI-SVR4) id JAA26643; Thu, 10 Jun 1999 09:58:40 +0100 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Sender: stuart@kestrel.ludwig.ucl.ac.uk Message-Id: In-Reply-To: <199906100301.XAA21709@hub.org> Date: Thu, 10 Jun 1999 09:56:10 +0100 To: pgsql-sql@postgresql.org, ssr@visti.net From: Stuart Rison Subject: Re: [SQL] fields with float[48] type question Hi Serguey, I can't explain the behaviour -although I've had similar "trouble" with AGGREGATES on floats. I potential work-around that could to work with your example though is: CREATE SEQUENCE test_seq INCREMENT -6 START 10000 MAXVALUE 10000 MINVALUE 0; CREATE FUNCTION get_nextval() RETURNS float AS 'SELECT nextval(\'test_seq\')/100.0' LANGUAGE 'sql'; then... SELECT get_nextval(); [first time] NOTICE: test_seq.nextval: sequence was re-created get_nextval ----------- 100 (1 row) SELECT get_nextval(); [22nd time] get_nextval ----------- 98.68 (1 row) problem is you have to multiply your starting value and the increment by whatever it takes to 'get rid' of decimal places. That fine if your increment is 0.06 but if it's 0.0000001225357 it becomes rather more silly! anyway HTH, regards, Stuart > 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?.. +-------------------------+--------------------------------------+ | Stuart Rison | Ludwig Institute for Cancer Research | +-------------------------+ 91 Riding House Street | | Tel. (0171) 878 4041 | London, W1P 8BT, UNITED KINGDOM. | | Fax. (0171) 878 4040 | stuart@ludwig.ucl.ac.uk | +-------------------------+--------------------------------------+