>Also recently Hugo found an interesting case when IN subquery behaved differently than EXISTS because of NULLs involved.
Actually I did not find anything, I just failed miserably to read the manual, as the behavior is documented and correctly pointed to me by Sergey. I am still embarrased by the whole incident, thanks for the reminder :)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges