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

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Support boolcol IS [NOT] UNKNOWN in partition pruning
Date: 2024-03-04 01:46:21
Message-ID: CAApHDvrFEEFqqV9cyOfDBbRAxrHgijtFo85b7oGF-93bxMzcyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 20 Feb 2024 at 15:38, David Rowley <dgrowleyml(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Smith 2024-03-04 01:55:21 Re: Synchronizing slots from primary to standby
Previous Message Michael Paquier 2024-03-04 01:44:34 Re: Injection points: some tools to wait and wake