> > 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
The given column is a date type column, with some records where
"date is not given". This "not given" is represented by NULL.
I saw it more elegant than assigning a date in the very past for
"not given", or using a boolean column called "date given".
After all, I consider using the additional boolean column.
Bye,
Baldvin