[sqlite] Re: What is the column value after ALTER TABLE ADD COLUMN?

[Igor Tandetnik]

Doug Nebeker <[EMAIL PROTECTED]>
wrote: 
UPDATE xyz SET newcol=function(other_column) WHERE newcol=null;

NULL is never equal to anything, not even another NULL. Make it

UPDATE xyz SET newcol=function(other_column) WHERE newcol is null;

Igor Tandetnik

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------