RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 - Mailing list pgsql-sql

From Hiroshi Inoue
Subject RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
Date
Msg-id 000a01bf6949$dde71020$2801007e@tpf.co.jp
Whole thread Raw
In response to Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4  (John Brothers <johnbr@mindspring.com>)
List pgsql-sql
> -----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

pgsql-sql by date:

Previous
From: John Brothers
Date:
Subject: Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
Next
From: Tom Lane
Date:
Subject: Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4