Jim,

J> A more general solution would be a comparison operator that returned
J> true if the two operands were equivalent -- either equal in value or
J> both missing. This would avoid a special case in a trigger while making
J> a useful construct available in all contexts. I'd be surprised if some
J> other database systems didn't already have such an operator; if so, we
J> should consider their choice of operator. If I were a less cynical
J> person, I'd suggest "==".

amen to *every*single*word*.
One who looks at the archives will find that it has been proposed and
discussed at length already in the past.

Ciao
--
Nando Dessena
mailto:nandod@...