[sqlite] Newbie stumper

Hi, when my categories table is empty: 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 Thanks for all help, Kai

Re: [sqlite] Newbie question

Thanks, Igor & Michael - your help is much appreciated. Cheers Kai On Mon, Mar 21, 2011 at 4:47 AM, Igor Tandetnik wrote: > Kai Peters wrote: >> given a table with two columns (SaleDate, SaleVolume) is it possible in one >> query to obtain >> the

[sqlite] Check for valid dates?

Hi all, is there a way to check for valid ISO 8601 dates? Thanks Kai ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users