On 27 Jan 2012, at 7:43pm, K Peters wrote: > Why would the second statement still return null if the first statements > returns 'null'? > > > select typeof(max(id)) from categories -- returns 'null' > select case max(id) when null then 1 end as NextID from categories
Matching with "null" does not work the same as matching with other values. "null" means "I don't know." so every value matches with it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
