On Fri, May 18, 2007 at 14:00:21 -0500, Doug Nebeker wrote: > UPDATE xyz SET newcol=function(other_column) WHERE newcol=null; > > Both of the above fail. What is the value in newcol?
The value is NULL, however you have to say "IS NULL": UPDATE xyz SET newcol=function(other_column) WHERE newcol IS NULL; NULLs aren't equal to each other: sqlite> .nullvalue <NULL> sqlite> select NULL = NULL; <NULL> -- Tomash Brechko ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
