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
___
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 following three column result set:
>>
>> SalesC
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
3 matches
Mail list logo