On Mon, Sep 19, 2005 at 04:33:27PM -0400, Tom Lane wrote:
This is a bad idea, because it translates x IS NULL into x = NULL
which is under no circumstances the same thing. It might coincidentally
fail to malfunction for btree indexes, depending on the specifics of the
= operator in use; but
Martijn van Oosterhout kleptog@svana.org writes:
Actually, it's two changes:
- In the btree index code, if SK_ISNULL is set, do the right thing
- If the query has col IS NULL, expand that to col =3D NULL in the index
quals
This is a bad idea, because it translates x IS NULL into x = NULL