Received: from ga.prestige.net (dns2.prestige.net [208.220.88.11] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id WAA98165; Thu, 27 Jan 2000 22:56:45 -0500 (EST) (envelope-from johnbr@mindspring.com) Received: from jb1 [208.246.188.22] by ga.prestige.net (SMTPD32-6.00) id A353215C009A; Thu, 27 Jan 2000 22:56:03 -0500 Message-Id: <4.1.20000127224856.00c97350@pop.mindspring.com> X-Sender: (Unverified) X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 Date: Thu, 27 Jan 2000 22:51:40 -0500 To: pgsql-general@hub.org, pgsql-sql@hub.org From: John Brothers Subject: Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 In-Reply-To: <200001271637.LAA23266@candle.pha.pa.us> References: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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. At 11:37 AM 1/27/00 -0500, Bruce Momjian wrote: >> Could you try the follwoing patch ? > >Hiroshi, I don't see this in the main tree, nor do I see it having been >requested for application. Should I apply it? > >> >> Regards. >> >> Hiroshi Inoue ------------ johnbr@incanta.net