Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f15Ja5x57954 for ; Mon, 5 Feb 2001 14:36:05 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f15JZs917789; Mon, 5 Feb 2001 14:35:54 -0500 (EST) To: Justin Clift cc: "pgsql-sql@postgresql.org" Subject: Re: HELP: Scarey pl/pgsql problem In-reply-to: <3A78CF0F.AD0F7A6F@bigpond.net.au> References: <200101131404.JAA01424@jupiter.jw.home> <3A78CF0F.AD0F7A6F@bigpond.net.au> Comments: In-reply-to Justin Clift message dated "Thu, 01 Feb 2001 13:50:55 +1100" Date: Mon, 05 Feb 2001 14:35:53 -0500 Message-ID: <17786.981401753@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/58 X-Sequence-Number: 1228 Justin Clift writes: > I'm having trouble with what MAY BE a bug in PL/PGSQL for PG 7.0.3 on > Linux (Mandrake Linux 7.2). > [ bogus roundoff behavior in date/time display ] This is a known silliness in the Mandrake distribution: their default compiler flags include both -O3 and -ffast-math, a combination that the gcc people will tell you does not work. The main result we've heard about is bogus roundoff behavior. I believe our recent Mandrake RPMs have been built with compiler flags that actually work, but if you got the files from someplace else or compiled them yourself then you might be vulnerable to this error. Check the mail list archives for more info, eg http://www.postgresql.org/mhonarc/pgsql-hackers/2000-08/msg00193.html regards, tom lane