On Tue, Dec 5, 2023 at 4:41 PM Peter Geoghegan <p...@bowt.ie> wrote: > "In general, when inequality keys are present, the initial-positioning > code only promises to position before the first possible match, not > exactly at the first match, for a forward scan; or after the last > match for a backward scan." > > My test case mostly just demonstrates how to reproduce the scenario > described by this sentence.
I just realized that my test case wasn't quite minimized correctly. It depended on a custom function that was no longer created. Attached is a revised version that uses btint84cmp instead. -- Peter Geoghegan
require_opposite_dir_repro_v2.sql
Description: Binary data