Horton

Re: Support boolcol IS [NOT] UNKNOWN in partition pruning

David Rowley <dgrowleyml@gmail.com>

View thread View on postgr.es
From: David Rowley <dgrowleyml@gmail.com>
To: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2024-03-04T01:46:21Z
Lists: pgsql-hackers 
On Tue, 20 Feb 2024 at 15:38, David Rowley <dgrowleyml@gmail.com> wrote:
> While working on 4c2369ac5, I noticed there's close to as much code to
> disallow BooleanTests in the form of "IS UNKNOWN" and "IS NOT UNKNOWN"
> in partition pruning as it would take to allow pruning to work for
> these.

I looked at this again and reminded myself that it's quite trivial. I
pushed the patch after doing a bit more work on the comments.

David

Commits

  1. Support partition pruning on boolcol IS [NOT] UNKNOWN