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 CAKFQuwZb12ZQAio5wXE-FpF=0URHe8RWk5sa-SE7jZiBsypQJA@mail.gmail.com
Whole thread Raw
In response to WHERE column = X AND column = Y will always be zero matching rows  ("[Quipsy] Markus Karg" <karg@quipsy.de>)
Responses 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 Thursday, August 3, 2023, [Quipsy] Markus Karg <karg@quipsy.de> wrote:

EXPLAIN SELECT column FROM Table WHERE column = X AND column = Y

 

…says that PostgreSQL actually wants to perform a Scan!

 

I wonder why squandering any resources into a Scan here


Mostly because no one wants to volunteer to write code to deal with poorly written queries, nor, more technically, expend compute resources looking for situations that should not happen.

David J.

pgsql-bugs by date:

Previous
From: Justin Tocci
Date:
Subject: Re: BUG #18047: ODBC to PG long transaction causes PANIC
Next
From: Laurenz Albe
Date:
Subject: Re: WHERE column = X AND column = Y will always be zero matching rows