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

From Tom Lane
Subject Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
Date
Msg-id 9736.949039195@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> Hiroshi neglected to mention that you'd probably need to drop and
>> recreate the index after applying the patch; if it's indeed out of
>> order, just patching the comparator bug isn't enough to fix it.

> Does Hiroshi's patch get applied?

Now that I understand the problem, yes, his patch is good as far as
it goes.  There are probably other places with the same problem...

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4