Ahh, thanks. So it is simply a syntactic transform, and not really a "proper" internal comparison operator change. Regards, Ed On Tue, 11 May 2004, Stephan Szabo wrote: > Use the full version or if you're generating the query strings on the fly > put only the check that matters (either the equality or the is null as > appropriate for the values). Or if all you care about is true/false, > possibly > select exists(select 1 from tmp where ...) > may be better. > > Transform_null_equals is meant convert a very specific x = NULL or NULL = > x into x IS NULL. It doesn't (nor is it meant to) change how nulls > compare. > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
