[PATCHES] [PATCH] Add support for IS NULL to btree indexes

Here is a patch that enables IS NULL to use a btree index. After mentioning it was really hard, I had a brainwave and here are the 80 lines of code necessary to make it work. What surprised me is that in various important parts most of the work had actually been done already. Actually, it's two

Re: [PATCHES] [PATCH] Add support for IS NULL to btree indexes

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

Re: [PATCHES] doc/FAQ_DEV: about profile

FAQ_DEV updated. Thanks. --- [EMAIL PROTECTED] wrote: Though there is a description for the profile in doc/FAQ_DEV: You can also compile with profiling to see what functions are taking execution time. The backend