Received: from mail.zhengmai.net.cn ([202.99.6.1]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBJ0jk629806 for ; Mon, 18 Dec 2000 19:45:47 -0500 (EST) (envelope-from laser@zhengmai.com.cn) Received: from zhengmai.com.cn (laser@[211.99.242.205]) by mail.zhengmai.net.cn (8.9.3/8.9.3) with ESMTP id IAA27950 for ; Tue, 19 Dec 2000 08:45:12 +0800 (BST) Message-ID: <3A3EB05E.C564D84A@zhengmai.com.cn> Date: Tue, 19 Dec 2000 08:48:30 +0800 From: "He Weiping(Laser Henry)" X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.18 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: some errors and/or bugs? Content-Type: text/plain; charset=gb2312 Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/54 X-Sequence-Number: 101 func.sgml line 251: cbrt(27.0) = 3.0, not 9.0, so it seems it's not the reault of: select cbrt(27.0); but someone's thinking. :-) and line 283 floor()'s result, 43, miss a minus, should be -43 and for the round( numeric ): laser_zh=# select round(42.5); round ------- 42 (1 row) is it correct? I think result should be 43. but for round( numeric, int): laser_zh=# select round(42.4352, 2); round ------- 42.44 (1 row) seems correct. Bug I don't know if there something related with my OS, I'm using Slackware 7.1 glibc 2.1.3. I could write some simple program to test it further, but need more hints. Regards Laser