Postgres Pro
Downloads
Home   >   mailing lists

Re: WHERE column = X AND column = Y will always be zero matching rows - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: WHERE column = X AND column = Y will always be zero matching rows
Date
Msg-id CAKFQuwYffZmZasYCuhd8hoJnoP9ftHpPXynk4Q+uZ6gTPaOfjQ@mail.gmail.com
Whole thread Raw
In response to AW: WHERE column = X AND column = Y will always be zero matching rows  ("[Quipsy] Markus Karg" <karg@quipsy.de>)
List pgsql-bugs
Tree view


On Thu, Aug 3, 2023, 07:53 [Quipsy] Markus Karg <karg@quipsy.de> wrote:

David,

 

thank you for your opinion, so it is a chance for future optimization.

 

Whether or not this „should not happen“ is a different discussion. 😉


Given that this has come up a number of times over the decades with the same response the practical reality of an optimization are basically zero.  You want to patch your own fork then sure, it is technically possible.

David J.

pgsql-bugs by date:

Previous
From: "[Quipsy] Markus Karg"
Date:
Subject: AW: WHERE column = X AND column = Y will always be zero matching rows
Next
From: Jaime Casanova
Date:
Subject: Re: WHERE column = X AND column = Y will always be zero matching rows