Thank you Igor and Tomash.
-----Original Message----- From: Tomash Brechko [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 2:14 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] What is the column value after ALTER TABLE ADD COLUMN? 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] ------------------------------------------------------------------------ ----- This email was sent to you by Reuters, the global news and information company. To find out more about Reuters visit www.about.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Limited. Reuters Limited is part of the Reuters Group of companies, of which Reuters Group PLC is the ultimate parent company. Reuters Group PLC - Registered office address: The Reuters Building, South Colonnade, Canary Wharf, London E14 5EP, United Kingdom Registered No: 3296375 Registered in England and Wales ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
