Postgres Pro
Downloads
Home   >   mailing lists

Re: How to use index in WHERE int = float - Mailing list pgsql-general

From Andrus
Subject Re: How to use index in WHERE int = float
Date
Msg-id gf7mnq$10lb$1@news.hub.org
Whole thread Raw
In response to Re: How to use index in WHERE int = float  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How to use index in WHERE int = float  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
> The IN-pullup code runs before constant-simplification does, so it
> doesn't see that as a simple join condition.

Seems serious design flaw.
How to change expression parser so that contant parts of expressions are
removed before IN-pullup?

Andrus.

pgsql-general by date:

Previous
From: "Nikolay Samokhvalov"
Date:
Subject: Re: again...
Next
From: Tom Lane
Date:
Subject: Re: How to use index in WHERE int = float