Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14676: neqsel is NULL dumb - Mailing list pgsql-bugs

From Marko Tiikkaja
Subject Re: [BUGS] BUG #14676: neqsel is NULL dumb
Date
Msg-id CAL9smLCwOQvbqLbP4x6r=F80cSKWfU_43Kj-dX0SKuAinexzJA@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14676: neqsel is NULL dumb  (Pantelis Theodosiou <ypercube@gmail.com>)
List pgsql-bugs
Tree view
On Mon, May 29, 2017 at 7:08 PM, Pantelis Theodosiou <ypercube@gmail.com> wrote:

Since you say that the majority of rows have NULL in nullable, I would try a partial index with:  WHERE (nullable IS NOT NULL)

Thanks, but I've already implemented a workaround.  I'm more interested in getting the actual problem fixed.


.m

pgsql-bugs by date:

Previous
From: Flo
Date:
Subject: Re: [BUGS] Can't restore view with pg_restore
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] Can't restore view with pg_restore