> > 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





---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to