Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA13362; Thu, 27 Jan 2000 23:35:15 -0500 (EST) (envelope-from Inoue@tpf.co.jp) Received: from cadzone ([126.0.1.40] (may be forged)) by sd.tpf.co.jp (2.5 Build 2640 (Berkeley 8.8.6)/8.8.4) with SMTP id NAA08133; Fri, 28 Jan 2000 13:35:10 +0900 From: "Hiroshi Inoue" To: "John Brothers" Cc: , Subject: RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Date: Fri, 28 Jan 2000 13:40:56 +0900 Message-ID: <000a01bf6949$dde71020$2801007e@tpf.co.jp> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: <4.1.20000127224856.00c97350@pop.mindspring.com> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Importance: Normal > -----Original Message----- > From: owner-pgsql-general@postgresql.org > [mailto:owner-pgsql-general@postgresql.org]On Behalf Of John Brothers > > I don't think that patch will work - Hiroshi whipped up that > patch for me a > week ago for a > different problem - we have a table with duplicate primary keys, which > seems to be > an arithmetic overflow problem because the index key values can be both > very large positive > and very large negative numbers. > What was the result on your environment after applying my patch ? My patch workded for your test case at least on my machine. Regards. Hiroshi Inoue Inoue@tpf.co.jp