[PATCH] Support SK_SEARCHNULL / SK_SEARCHNOTNULL for heap-only scans

From: Aleksander Alekseev <aleksander(at)timescale(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: [PATCH] Support SK_SEARCHNULL / SK_SEARCHNOTNULL for heap-only scans
Date: 2023-02-13 14:59:13
Message-ID: CAJ7c6TPKeh7UwEN9ORqP_dmR8uxiFhxT8Pecq01zw1HKpTBMBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

A colleague of mine wanted to use a ScanKey with SK_SEARCHNULL flag
for a heap-only scan (besides other ScanKeys) and discovered that the
result differs from what he would expect. Turned out that this is
currently not supported as it is explicitly stated in skey.h.

Although several workarounds come to mind this limitation may be
really of inconvenience for the extension authors, and implementing
corresponding support seems to be pretty straightforward.

The attached patch does this.

--
Best regards,
Aleksander Alekseev

Attachment Content-Type Size
v1-0001-Support-SK_SEARCHNULL-SK_SEARCHNOTNULL-for-heap-o.patch application/octet-stream 10.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Drouvot, Bertrand 2023-02-13 15:07:25 Re: Helper functions for wait_for_catchup() in Cluster.pm
Previous Message tender wang 2023-02-13 14:32:32 ERROR: permission info at index 1 ....