Re: WHERE column = X AND column = Y will always be zero matching rows

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "[Quipsy] Markus Karg" <karg(at)quipsy(dot)de>
Cc: PostgreSQL Bug List <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: WHERE column = X AND column = Y will always be zero matching rows
Date: 2023-08-03 15:02:11
Message-ID: CAKFQuwYffZmZasYCuhd8hoJnoP9ftHpPXynk4Q+uZ6gTPaOfjQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Aug 3, 2023, 07:53 [Quipsy] Markus Karg <karg(at)quipsy(dot)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.

>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jaime Casanova 2023-08-03 17:55:18 Re: WHERE column = X AND column = Y will always be zero matching rows
Previous Message [Quipsy] Markus Karg 2023-08-03 14:53:36 AW: WHERE column = X AND column = Y will always be zero matching rows