Kovacs Baldvin <kb136(at)hszk(dot)bme(dot)hu> writes:
> After these I use ~= if I need lines with NULLs in both to be selected.
Perhaps you should reconsider your data model. You seem to be treating
NULL as if it were a real value, which is something that SQL discourages
rather strongly...
regards, tom lane