pgsql: Support partition pruning on boolcol IS [NOT] iso-8859-1 - Mailing list pgsql-committers

From David Rowley
Subject pgsql: Support partition pruning on boolcol IS [NOT] iso-8859-1
Date
Msg-id E1rgxOA-001xRk-2R@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Support partition pruning on boolcol IS [NOT] UNKNOWN

While working on 4c2369ac5, I noticed we went out of our way not to
support clauses on boolean partitioned tables in the form of "IS
UNKNOWN" and "IS NOT UNKNOWN".  It's almost as much code to disallow
this as it is to allow it, so let's allow it.

Discussion: https://postgr.es/m/CAApHDvobKtcN6+xOuOfcutfp6T7jP=JPA9y3=MAEqnuKdDsQrw@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/07c36c1333e00df5a4baf6b04ba2f3f300f57d69

Modified Files
--------------
src/backend/partitioning/partprune.c          | 71 +++++++++++++++------------
src/test/regress/expected/partition_prune.out | 56 +++++++++++++++++----
src/test/regress/sql/partition_prune.sql      |  7 +++
3 files changed, 93 insertions(+), 41 deletions(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Add PostgreSQL::Test::Cluster::wait_for_event()
Next
From: David Rowley
Date:
Subject: pgsql: Optimize GenerationAlloc() and SlabAlloc()