Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:> Whereas IN seems to not working ok when negated as shown below:
If the sub-select returns any NULLs then this behavior is per SQL spec.
regards, tom lane